Unable to add a lookup field to a table in Access 2010 - receive "The database cannot be opened because the VBA project contained in it cannot be read."
Sunday, July 01, 2012 11:10 AM
I have just installed Access 2010 onto a clean Windows 7 x64 machine with no existing issues I know of.
I then created a new Access database, and tried to add a Lookup field to the one table in that database. I get this error:
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports ..."
I have saved the database into a Trusted Location.
So, my question: how should I go about creating a new empty database, with one table, and which has a lookup field?
Thanks for reading my post!
Monday, July 02, 2012 3:39 AMModerator
It seems to be caused by the Access 2010 program has been installed properly.
Firstly, try the following method:
If it doesn’t work, please uninstall your Office suite using the Fix It utility in the following article. This utility uninstalls your Office suite and then tries to clean up all of the remnant Office files on your machine (not your actual document files). Then after this completes, I would recommend trying the install of your Office suite again to see if this helps.
290301 - How do I uninstall Office 2003, Office 2007 or Office 2010 suites if I cannot uninstall it from Control Panel?
TechNet Community Support
- Edited by Rex ZhangModerator Monday, July 02, 2012 3:40 AM
Tuesday, July 03, 2012 10:06 AM
Thanks for your reply.
I have carefully followed your directions, and I get the same issue again - there appears to be no way to create a lookup field in Access 2010.
Thursday, July 05, 2012 1:14 AMModerator
The next step we can try is to delete the following folders and reinstall Office again:
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7
A similar case can be found here:
Please Note: Since the following web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.
TechNet Community Support
Thursday, July 05, 2012 1:18 PM
Check out the threads below. It may help you.
Monday, July 09, 2012 1:03 AMModerator
Wednesday, July 11, 2012 9:56 AM
The VBA6 and VBA7 folders were not present after uninstalling and running the Fixit programs. So, this time I installed Access 2010 SP1 first, then Office Standard, then Visio. Access is now OK. All x64 (which they were on previous attempts).
All I can suggest here is that installing Access 2010 AFTER Office Standard and/or Visio was the cause.
Thanks very much for your assistance (and to you, too, bisla.wing).
- Marked As Answer by Rex ZhangModerator Thursday, July 12, 2012 12:51 AM