Problem in Access 2007

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

krazeecrw

Thread Starter
Joined
Oct 25, 2002
Messages
383
I am trying to import the Global Address List from my Exchange e-mail account to Access 2007 and am having difficulties. When I select the Global Address list in the Import Exchange/Outlook wizard and click Next, I get the following error message:

Method 'Value' of object "Field2" failed

I can import other address books fine. I uninstalled and reinstalled and did a repair but that did not work either. Any ideas on how to solve this?
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Usually this kind of error occurs with Excel, the Access Import Wizard takes the first row as a heading, it then uses the second row to test and set the Field Type, ie. text, number, date etc.
This error occurs when a row further in to the Table changes from the one that the Wizard decided it should be, ie it should be a number and suddenly it has a some text.
To try and overcome this Import the data in to a table that you have prepared where you set Field2 to "Text", which should accept just about anything.
 
Joined
Jun 18, 2008
Messages
1
MS says this is a bug in Office 2007 SP1. They are working on a hotfix. Here is the workaround...

SHORT DESCRIPTION OF PROBLEM:
=============================
You are receiving the following error message when importing the Global Address List from Outlook / Exchange into Access: Method 'Value' of object 'Field2' failed



MICROSOFT PRODUCT VERSION AND SERVICE RELEASES:
===============================================
Version of Access: Access 2007 SP1
Operating System: Windows XP Pro SP3



COMPLETED ACTIONS TAKEN AND RESULTS:
======================================

At this time the best workaround to the issue if you have SP1 installed is to replace the new version of the aceexch.dll (version 12.0.6048.5000 - 12.00.6211.1000) file with a copy of the older aceexch.dll file (version 12.0.4518.1014).


The easiest way to find a copy of the older aceexch.dll file is to do a search on your XP machine and the older file most likely will be stored in a cached folder.



After you find the older file, implement the following steps:

1. Navigate to C:\Program Files\Common Files\Microsoft Shared\OFFICE12 and rename the current aceexch.dll file to aceexch.old



2. Move the old copy of the aceexch.dll (12.0.4518.1014) into the folder (C:\Program Files\Common Files\Microsoft Shared\OFFICE12)



3. Try importing the GAL into Access. It should now work successfully.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top