If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
tempmsysaccessobjects
When I try to compact my db I get an error that says my
table tempmsysaccessobjects already excists. How do I fix this? Chris |
#2
|
|||
|
|||
tempmsysaccessobjects
"Chris B" wrote:
When I try to compact my db I get an error that says my table tempmsysaccessobjects already excists. How do I fix this? Chris I'd suggest creating a new, empty database and using File... Get External Data... Import to import everything from your database. It appears that a compaction didn't run to completion and your database may be corrupted! If you have any objects with VBA code, type Ctrl-G to open the VBA editor, and select Debug... Compile my database immediately after the import to prevent the dreaded "Network Connection May Have Been Lost" bogus error. -- John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|