Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Corrupt access database

Status
Not open for further replies.

Mojak

Technical User
Aug 16, 2001
66
SG
How can I fix a corrupt access xp database. I tried the built in tool to no avail.

Thanks!!!
 
Perhaps it's too simple, but if you know which tables are corrupt and you can view the data you can often fix them using queries.

For example, If you know that record #1652 is corrupt in &quot;TblMyData&quot; then run a &quot;make table&quot; query from that table with a condition on ID as <=1651 AND >=1653. That will create the table skipping the corrupt record.

Of course, if you have too many corrupt records this will be time consuming as you will have to run >= clauses multiple times (the second time you run the query it will be an &quot;append query&quot; not a make table query. I have used this when I had up to 30 corrupt records - and probably would for more as the data is very important to me.

All of this is useless if you don't know the source of your corruption, however.

Hope this helps.

Adam
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top