Microsoft Access can't find the wizard.

In my particular case, I had originally installed a 64-bit version of Office on my 64-bit PC.  Later, I uninstalled that version and installed the 32-bit version (for compatibility with other software).  I don't know if that was the issue or if the installer is just messed up, but the path to the ACCWIZ directory was not in the list of trusted locations.  What was there was:

C:\Program Files\Microsoft Office\Office14\ACCWIZ\

What I needed was:

C:\Program Files (x86)\Microsoft Office\Office14\ACCWIZ\

After adding the new path to the list of trusted locations and adding the Access Add-ins using the Add-in manager, all the Exernal Data Source wizards seem to be working.

Previous to this, I had tried a lot of things.  I had tried renaming the wizards to xxx.old and having Access recreate them.  I had even uninstalled and reinstalled Office 2010 a couple of times making sure to do the custom install to insure the wizards were installed.  Still no joy.  Only after fixing the trusted locations would the wizards work.  Thanks to Kathy S. for the suggestion!

I have the same problems with Office 2007/Access 2007 for several users - unable to go to External Data and import Excel spreadsheet - fails on teh same wizard error reported in this thread - wish there was a fix - I did everything mentioned without any resolve.  This is a huge pain.

Hi Christopher,

What do you have listed as trusted locations within Access 2007?  To look at this you can do the following:

+>Open Access 2007 and then click on the Office button -> Access Options.

+>In the Access Options dialog, click on Trust Center and then click the Trust Center settings button.

+>Then click on the Trusted Locations tab.

+>You should then see your trusted location listed. 

What locations do you have listed? 

Do you have an entry for C:\Program Files (x86)\Microsoft Office\Office12\ACCWIZ\ or C:\Program Files\Microsoft Office\Office12\ACCWIZ?

Best Regards,

Nathan O.

Microsoft Online Community Support

Hi everyone,

I know this is a very old thread but I had to share some relevant information that might help others solve this issue.

I had the same issue with Access 2013 on Windows 8 (in an Active Directory environment).

While trying to link an excel database I had the same mentioned error regarding the wizard.

I tried all the mentioned solutions and none worked.

So what I did is this:

• Backed up the users profile directory "c:\users\username".
• Logged in as Administrator and deleted the users profile (right click on computer-chose properties, chose advanced system settings and then chose settings of the user profiles).
• After deletion and a reboot, logged in as the deleted profile user (profile was recreated).
• Copied back all the relevant information (desktop, documents, favorites...).
• Problem solved.

I hope this helps.

This was probobly an error with something in the registry, if anyone forund a more delicate solution I'll be happy to hear about it.

Please see here to see if this helps http://support.microsoft.com/kb/2581301