Access closes when compacting and wont repair

[RussCRM]

Whenever I try to backup my database or compact it, I get the
"Microsoft Access has encountered a problem and needs to close" deal
with the option to repair. When I attempt to do that, it tries to
backup the database and I get the same thing over and over.

In addition, whenever I try to export or copy my main table, which is
"tblGuest", it corrupts my database and then I get an error message
saying my file is no longer an Access database.

Any suggestions?

[timmg]

Re: Access closes when compacting and wont repair

Make backups.

First try creating a blank database and importing all of the objects
from the suspect version. Compact, test, and try to recreate the
original problem. This may put you in the clear.

If not, try decompile. check here for help http://allenbrowne.com/tips.html

If you can't make that work you might search microsoft for jetcomp.exe

And if that doesn't work there are several comercial ventures that
will try and recover your application. I don't have a preference
there.

Good luck

tim mills-groninger

On Mar 7, 2:46 pm, RussCRM <srusskin...@gm ail.comwrote:

Whenever I try to backup my database or compact it, I get the
"Microsoft Access has encountered a problem and needs to close" deal
with the option to repair.  When I attempt to do that, it tries to
backup the database and I get the same thing over and over.
>
In addition, whenever I try to export or copy my main table, which is
"tblGuest", it corrupts my database and then I get an error message
saying my file is no longer an Access database.
>
Any suggestions?