Error when trying to compact and repair

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

I have a 16mg access DB on a central file and print
server. Every time I try compact and reapir the DB, it
crashes out with the debug option. It also does this if I
try export a table to an excell spreadsheet.
Pls assist.
 
I have a 16mg access DB on a central file and print
server. Every time I try compact and reapir the DB, it
crashes out with the debug option. It also does this if I
try export a table to an excell spreadsheet.
Pls assist.
Click to expand...

You may have systems table corruption. Make sure that nobody has the
database open; create a new, empty database and use File... Get
External Data... Import to import all the objects.

If you have multiple users sharing the same single database, you
should very strongly consider using the Database Splitter Wizard
(Tools... Database Utilities) to split the database into a "backend"
with just the tables, on the server, and a "frontend" with all the
forms, reports, etc. with tables linked. Each user would have their
own copy of the frontend on their own machine.
 
What does the Debug message say?
Does it point you to a line of code?

It certainly sounds as if you have some sort of corruption.
Be sure you make a copy of your database before doing anything else.
Anything else may make it worse.
Here's one thing you could try after making your copy.

You might try opening Access, but not the database.
Select Tools - Database Utilities - Compact and Repair,
then browse to your database.

HTH
- Turtle
 
Robin said:
I have a 16mg access DB on a central file and print
server. Every time I try compact and reapir the DB, it
crashes out with the debug option. It also does this if I
try export a table to an excell spreadsheet.
Click to expand...

As John and Turtle have indicated this is a sign of corruption. If
you need additional assistance see the Access Corruptions FAQ at my
website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top