Table 'MSysAccessObjects' already exists

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rafaqatkhan
    New Member
    • Sep 2012
    • 1

    Table 'MSysAccessObjects' already exists

    While trying to open M S Access data base following error appears.

    Table 'MSysAccessObje ct' already exists
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    What version of Access are you using and what format is the database file in?

    Standard fix is to open a new database and attempt to import the user defined tables, queries, etc... nothing with a "MSsys" in the name. Then open the VBA editor and do a compile.

    Also, http://allenbrowne.com/ser-47.html for some hints about database corruption.
    Last edited by zmbd; Sep 26 '12, 12:44 PM.

    Comment

    Working...