CAN NOT COMPACT DATABASE ANYMORE

[ALY]

I compact a rather large database at least once a week. 2
weeks ago when I went to compact the database I got a
message that the database was no longer a .mdb database
anymore. It then asked if I would like to repair the
database, I said yes. The next message said that it was
not able to repair the database.

I have not been able to compact the database in the last 2
weeks, due to this message. The database is no longer
able to be opened or used once that message is received
after trying to compact access.

When this message is up the database has to be renamed and
a copy of the database is then used. It is constantly
backed up.

Has anyone heard of this happening, or know how to fix it?
Thanks so much.

 

[Denise]

I just experienced the same problem. Has anyone seen a
resolution?

 

[John Vinson]

I just experienced the same problem. Has anyone seen a
resolution?

The database is corrupted, possibly salvagable but quite possibly not.
Do you have backups? (If not... you now know why backups are
considered essential... :-{( )

You can try creating a new, empty database and using File... Get
External Data... Import to import whatever is not trashed. Or, you may
be able to get some help from the estimable Peter Miller at
http://www.pksolutions.com - but it is quite possible that this
particular database is toast.

 

[GVaught]

Do you try to compact with other users in the database? If so, this will
corrupt a database faster than you can say, Ah sh.....t

In addition to John's suggestions you might also want to split your database
into a back-end/front-end scenario. For more information on 'splitting a
database' see Help or visit Microsoft's Knowledgebase website. A split
database also helps prevent corruption to a database especially if someone
closes down their computer improperly with the db open or you have a power
failure while the database is open. Since the users links their front-end to
the back-end tables, them shutting down their computer will not destroy the
back-end database.Splitting also helps making changes to queries, forms,
reports or code changes easier to distribute.

Just a thought to consider.