freezing application error

  • Thread starter Thread starter Phil Jones
  • Start date Start date
P

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
 
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
 
Cheers Sandra : -)

Thanks for that

Phil

Sandra Daigle said:
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.

Phil said:
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
Click to expand...
Click to expand...
 
Back
Top