Corrupt Access Databases

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
 
B

Bob Howard

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!
 
Top