temp file

[Bernard]

I have two accccess databases on one server. One is
joined to it's security mdw file, the other is launched
through a shortcut that specifies the other mdw security
file. The problem, when I close the second file I get the
following message: "TempMSysAccessObjects" already exists.
Can someone help me?


Bernard

 

[Joan Wild]

Open the problem database and try to delete the TempMSysAccessObjects table
(first you'll need to show system tables via Tools, Options).

Once you've deleted it, compact the database and then rehide the system
tables.

If you can't delete it, then create a new database and import all objects
from the old (don't import any system tables).

Note that doing this, you will lose all security settings on the objects.
You'll find this utility helpful in saving the permissions and then
reapplying them in the new database.
Look for DBUtilities 1.0 at
http://www.daiglenet.com/MSAccess.htm