Problem in Access 2007

[krazeecrw]

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]

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.

 

[RRman]

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.