prob....... on database closing

[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

 

[Allen Browne]

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

 

[krish]

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.




.