Error when trying to compact and repair

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.
 
J

John Vinson

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.

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.
 
M

MacDermott

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
 
T

Tony Toews

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top