Results 1 to 3 of 3
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    MSys(tables) (2000)

    <P ID="edit" class=small>(Edited by bfxtrfcmgr on 26-Feb-03 08:42. )</P>In this stand-alone db the Options/General setting for 'Compact on close' is set to yes. This morning I closed the application (it is usually left on for days or weeks at a time) and received the message "The Table 'TempMSysObjects' already exists". As far as I could tell the db did not compact. I re-opened the db in design view and discovered six new tables that were not there before:

    MSysAccessObjects
    MSysAccessXML
    MSysACEs
    MSysObjects
    MSysQueries
    MSysRelationships

    These tables have the property of "hidden" and any attempt to remove them generates the message "The database engine could not lock table 'MSysAccessObjects (in that case) because it is already in use by another person or process".

    Although it has been some time since I had closed the db, I can't recall anything I might have done to create the problem. We did try to copy the db over to a laptop a few weeks ago, but I wasn't involved in that attempt (it failed as far as I know). In any case, I can't be certain that the db was closed (and compacted) after that attempt.

    Any clues? Any help greatly appreciated!
    ================================================== ====
    I just opened a new (blank) db and the same MSys(Tables) come up there too! I've never seen these before.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MSys(tables) (2000)

    All tables whose name begins with MSys are system tables; you should never modify or delete them.

    By default, you don't see them. You can hide/unhide them by selecting Tools/Options..., View tab and (un)checking the System Objects check box. I recommend unchecking it; under normal circumstances you don't need to see system objects.

    Your database may be corrupt, but perhaps it can be repaired. Try the following:
    <UL><LI>To be on the safe side, make a backup copy.
    <LI>Try compacting again. If you get no error message, you may be in luck.
    <LI>Otherwise, download JetComp.exe from ACC2000: Jet Compact Utility Available in Download Center. This stand-alone utility can repair some problems the built-in compact-and-repair can't handle.
    <LI>If that doesn't help either, create a new blank database, and try importing all objects (tables, queries, forms, ...) from the problem database. Note: you shouldn't have system objects visible when you do this, otherwise Access will try to import those too.
    <LI>Your last resort is a backup copy from before the problem occurred.[/list]I hope that one of these steps help.

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: MSys(tables) (2000)

    Thanks, once again, Hans!!

    1. The internal Compact and Repair failed as previously attempted.
    2. Jet Comp (thanks) DID compact, but did not repair (same error with internal Compact and Repair after re-opening original db)
    3. Created new db without MSys objects diplayed and imported objects from old db. Internal (Access) Compact and Repair now working!!

    Thanks Again!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •