prob....... on database closing

  • Thread starter Thread starter KRISH
  • Start date Start date
K

KRISH

Hi,
anyone help me how to solve the following prob:
whenever i close my database it is showing an
error "Table 'TempMSysAccessObjects' already exits'.
please guide how to solve the prob.
thanks
krish
 
This is a temp table that you can safely delete, but you have to be able to
see it first.

1. Go to:
Tools | Options | View
and check the boxes for Hidden and System.
Close the dialog.

2. Select the Tables tab of the Database window, and delete the problem
table.

3. Compact the database:
Tools | Database Utilities | Compact

4. Uncheck the Hidden and System boxes again that you set at step 1.

More info:
http://support.microsoft.com/default.aspx?scid=kb;en-us;818099
 
thanks a lot Mr. Allen Browne
krish
-----Original Message-----
This is a temp table that you can safely delete, but you have to be able to
see it first.

1. Go to:
Tools | Options | View
and check the boxes for Hidden and System.
Close the dialog.

2. Select the Tables tab of the Database window, and delete the problem
table.

3. Compact the database:
Tools | Database Utilities | Compact

4. Uncheck the Hidden and System boxes again that you set at step 1.

More info:
http://support.microsoft.com/default.aspx?scid=kb;en- us;818099

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
 
Back
Top