Corrupt Access Databases

  • Thread starter Thread starter AFKAFB
  • Start date Start date
A

AFKAFB

Hi
I think my Access DB is corrupt.
Most of the time it seems to be okay.
But tonight i noticed that an update query would not update a table. I
tried everything and i could see that i could update other tables.
I scrolled through the opem table and realised that i could not do much
in the table. I cannot not type values into it at all.
Its the only table i've a problem with but i cannot see whats wrong
with it. I've noticeed in the past few days that when i try to create
some forms it rejects the number of joins and promptly kicks me out of
the database.
How wouldi know if the DB is corrupt.
regards
chris
 
Have you done a compact/repair operation? This sometimes helps.

Another possibility is to rename your database, open a blank Access database
under the desired name, and import eveything (tables, queries, forms,
reports, etc. --- everything) into it. Then open one of the forms, go into
the VBA editor, re-establish your VBA references, and re-compile the code.
The re-establish any startup options, Access options, etc. Save the result.
Test. Pray!
 
Back
Top