By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

Access closes when compacting and wont repair

P: n/a
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?
Mar 7 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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...@gmail.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?
Mar 7 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.