Creating New Table After Compact

[GettingIrritated]

I have set my database to Compact On Close. It compacts and closes ok BUT it
then creates an all new database. You cannot open the database and it is a
massively smaller database but it is still like 62 MB (the original is 2 GB).
Has anyone else had this problem and does anyone know how to fix this
problem?

I have worked with databases for years and I have never come across this
problem before! HELP!

 

[John Vinson]

I have set my database to Compact On Close. It compacts and closes ok BUT it
then creates an all new database. You cannot open the database and it is a
massively smaller database but it is still like 62 MB (the original is 2 GB).
Has anyone else had this problem and does anyone know how to fix this
problem?

I have worked with databases for years and I have never come across this
problem before! HELP!

You may have a corrupt database; 2 GByte is the limit, and once a
database exceeds that limit, strange things can happen.

Creating a new database is exactly how Compact works: it creates a new
database (named db1.mdb, or db2.mdb or the like if that file already
exists), copies everything from your database into it, and deletes the
old database. However, if the copy process cannot be completed because
of corruption, you may end up with both copies; or if you do not have
Delete permission on the folder containing the database it may keep
the old file around.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps