freezing application error

[Phil Jones]

I have a database setup which when it stands for a while it freezes and
locks the pc up and displays this error message:

Table 'TempMySysAccessObjectsalreadyexists'

Any idea's why this would occure?

Many thanks
Phil Jones

 

[Sandra Daigle]

Hi Phil,

You probably have Compact on Close set in the database options and the
compact is failing. Here's how to correct the problem:

Try deleting 'TempMSysAccessObjects'.

Open the database
Click Tools->Options->View
Check the box for View System Objects
Go to the database window and under tables, find and delete
TempMsysAccessObjects.
Compact the database (hopefully it will work now)
Go back to Tools->Options->View and uncheck the box for View System Objects

If this doesn't work you may need to import everything into a new database
file.

PRB: "Table 'TempMSysAccessObjects' Already Exists" Error Message May Occur
While Using the Compact and Repair Database Utility
http://support.microsoft.com/default.aspx?scid=KB;EN-US;818099

 

[Phil Jones]

Cheers Sandra : -)

Thanks for that

Phil

Hi Phil,

You probably have Compact on Close set in the database options and the
compact is failing. Here's how to correct the problem:

Try deleting 'TempMSysAccessObjects'.

Open the database
Click Tools->Options->View
Check the box for View System Objects
Go to the database window and under tables, find and delete
TempMsysAccessObjects.
Compact the database (hopefully it will work now)
Go back to Tools->Options->View and uncheck the box for View System Objects

If this doesn't work you may need to import everything into a new database
file.

PRB: "Table 'TempMSysAccessObjects' Already Exists" Error Message May Occur
While Using the Compact and Repair Database Utility
http://support.microsoft.com/default.aspx?scid=KB;EN-US;818099


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have a database setup which when it stands for a while it freezes and
locks the pc up and displays this error message:

Table 'TempMySysAccessObjectsalreadyexists'

Any idea's why this would occure?

Many thanks
Phil Jones