Table 'TempMSysAccessObjects' already exists

[JoshuaAnthony]

HELP: "Table 'TempMSysAccessObjects' already exists."

Have been getting this message when closing my database recently and am a little worried about it. Anybody know what causes this and how I can fix it?

Also, in the directory where my database is stored, other copies seem to keep appearing when people exit the database ('db1', 'db2', etc...). Anybody know what might cause this and how I could stop it?

Thanks,

Joshua

 

[ghudson]

The db1, db2, etc. files are failed attepts to compact the db. The 'TempMSysAccessObjects' already exists is another compacting failure problem. You should import all of the db objects into a new db. Do you have the "compact on exit" turned on? Is the db split?, if not it should be split for a true multi-user db.

HTH

 

[JoshuaAnthony]

Yes I have "compact on exit" turned on.

Do I need to import them all into one database? What exactly do you mean by that? What if I have just been deleting the failed attempts? Have I lost essential data (it's only a trial at the moment but would be good to know for the future)?

I can follow the wizard instructions to split my database but what exactly is the purpose of this?

Thanks very much for your help!

Joshua

 

[JoshuaAnthony]

Plus what might actually be causing the compaction to fail?

 

[WayneRyan]

Joshua,

The db1, db2, ...

comes from Access's method of compacting a db. When Access
compacts, it opens a new DBn. Where n is the next "number"
in its sequence. It copies all objects to the new DBn and,
if successful, deletes your DB, renames DBn to your DB's name
and you're OK.

When it is traversing your DB and finds something that it can't
"understand", it throws an error and just quits. In 99% of the
cases the "new" DBn file is OK, and only the BAD object is not
in there.

Solution: Don't compact/repair ever ...

Just joking. You can Backup frequently so that you don't
encounter this, and you can also individually import your
database objects into a new Blank database.

Wayne

 

[JoshuaAnthony]

Thanks for that. I do have quite a few database objects though. Is there anyway to automate this (other than "compact and repair"!)? I don't mind so much the copying and pasting but the fact that I have to type the name of the table/query/form, in the new database means I risk mis-typing something and the database screwing up!

 

[WayneRyan]

Joshua,

NO !!

Don't retype anything. This is obviously not a perfect science for
our good "fiends" at MicroSoft. If you leave a production DB alone
for even a week or so, when you come back, it'll be "Brain Dead".

Sometimes, thing go off-kilter for those guys. I can leave ORACLE
DBs alone for months at a time and life's OK.

Whenever you see that something (that is right) just doesn't work
anymore. There are a few "simple" steps that you must take.

One is missing references. All of a sudden, the Mid function does
not work any more. See "References" in this Search Facility.

Or a form just doesn't behave like it used to (with no design
changes). Then maybe a Compact/Repair will fix it.

If that doesn't do it, import all objects into a New, Blank DB and
Voila! Sometimes it works.

Sometimes (rarely), a form just goes "Brain Dead" and the only
alternative is to re-create it.

Back up early and often! And enjoy the ride...

Wayne

 

[ghudson]

You need to open up a new access database. Then you need to import all of your database objects [all tables, all forms, etc] from the old problem db into the new db. Follow this using the menu bar options...

Click File, Get External Data, Import, find your old db, click the import button, click the Select All button within each object tab, click the Options button and check all options, click the OK button to import all of the objects from your old bad db into your new db.

 

[JoshuaAnthony]

Sweet. That's fixed it. Thanks guys!

 

[WayneRyan]

Josh,

Glad to hear it! But ...

[rant]
Why does this have to happen in the first place? Access is the
most unstable s/w product I've seen. You could even leave a
DBase app for a month and not come back to find it "Brain Dead".

Do .MDE's behave this way?
[/rant]

Wayne

 

[ghudson]

Wayne,

You should ask Mile-O-Phile if he can add a new quote code option to the forum for the rants.

[rant]What the ?[/rant]

 

[Mile-O]

You should ask Mile-O-Phile if he can add a new quote code option to the forum for the rants.

[sarcasm]What a wonderful idea![/sarcasm]