Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
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."

Answered 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
     
     
    Sign In to Vote
    0

    Hi,

    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!


     

All Replies

  • Monday, July 02, 2012 3:39 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    It seems to be caused by the Access 2010 program has been installed properly.

    Firstly, try the following method:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;2581301

    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?
     
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;290301

    Sincerely
    Rex Zhang

    Rex Zhang

    TechNet Community Support


     
  • Tuesday, July 03, 2012 10:06 AM
     
     
    Sign In to Vote
    0

    Hi Rex,

    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 AM
    Moderator
     
     
    Sign In to Vote
    0

    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.

    http://stackoverflow.com/questions/1611828/access-2007-wizards-wont-run


    Best regards,

    Rex Zhang

    TechNet Community Support

     
  • Thursday, July 05, 2012 1:18 PM
     
     
    Sign In to Vote
    0

    Hello,

    Check out the threads below. It may help you.

    http://social.msdn.microsoft.com/Forums/pl-PL/accessdev/thread/fd81fb44-f6c7-4731-b852-789a14c45961

    http://social.msdn.microsoft.com/Forums/pl/accessdev/thread/ff6abf39-5021-4131-8619-943f46aa24c0

     
  • Monday, July 09, 2012 1:03 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    Just checking in to see if the suggestions were helpful. Please let us know if you would like further assistance.

    Best Regards, 

    Rex Zhang

    TechNet Community Support

     
  • Wednesday, July 11, 2012 9:56 AM
     
     Answered
    Sign In to Vote
    0

    Hi Rex,

    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).