Compacting Error

J

James

When I try a Compact and repair from the tools menu, Access says the
following: Table 'TempMSysAccesObjects' already exists.
It wont let me go any further in the compacting process.
I can't find any Object or table that has that name.

How can I get rid of this and Compact?
 
6

'69 Camaro

Hi, James.

Make a copy of your database, then apply Method 1 of the solutions described
in the following KB article on the copy:

http://support.microsoft.com/?id=818099

Then, try compacting the copy. If that doesn't work, then try Method 2.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
J

James

Hi Gunny

Thanks for this, Method 2 seemed to help and I can now compact. However some
of the Subforms I had running in the original version no longer want to run
in the new copy? Access says that I must have misspelled the form or that it
refers to a macro. I have tried to copy the contents of each subform from
directly from one to the other, but there are a lot of these. Is there
another way around it?

Thanks
James
 
6

'69 Camaro

Hi, James.

It sounds like the original database was corrupted and importing all objects
into the new database imported some of the corrupted objects, namely these
subforms. Have you compacted and repaired the new database to see whether
this fixes it? Make a copy of the new database first, then compact and
repair the copy.

If that doesn't help, you can try importing these subforms again from the
original database. You'll need to rename the current subforms in the new
database though, otherwise the new imports will have the same name with a
"1" appended to the end of the subform's name, and the main forms that use
these subforms won't open the new ones because they have the wrong name.

If that doesn't work, then either copy/paste each subform from the original
database into the new database or restore these subforms from a backup.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
P

Peter De Baets

You might want to try creating a new Access database, then import all
your objects from the old database into the new one.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com
 
Top