Database Repair

  • Thread starter Thread starter SanDeep
  • Start date Start date
S

SanDeep

I am trying to open my database and it says that my
database needs to be repaired or is not a database file.
Then it asks Do I want Microsoft Access to attempt to
repair this database.
I just wonder If I say yes and it repairs it the would I
be loosing some of my records. Is there a way for me to
know which records I have lost.

Thanks in advance.
SanDeep
 
Hmmm, unfortunately, if you say "No" you will be unable to
open your database. Unless you have a backup or an
extremely good memory, I don't believe there is a way to
track what records might be lost.
 
SanDeep said:
I am trying to open my database and it says that my
database needs to be repaired or is not a database file.
Then it asks Do I want Microsoft Access to attempt to
repair this database.
I just wonder If I say yes and it repairs it the would I
be loosing some of my records. Is there a way for me to
know which records I have lost.
Click to expand...

Excellent question. Thanks for asking and not being too hasty.

1) Make a copy of the file.

2) For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

3) About all you can do is compare the number of records in the tables
from a backup MDB to the new one.

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
 
I am having a similiar problem. I copied my database to
another server so that 5 of my coworkers could use it to
input data. It works fine for 1 day and then it sends me
the same message about neededing repair. When I ask it to
repair the base it says it cannot be repaired and locks me
out.

Have you solved your problem yet? Would it also apply to
solving mine? any help would be appreciated.

Thanks
Betty
 
Back
Top