Access Database Problem

[Lance]

I have a website on a server running Windows 2000 Advanced Server.
When I download the database and run Compact and Repair Database using
Windows XP and Access 2000 if performs corrected. I then reupload the
database and the Queries in my website no longer work. I then download the
database to see why there are problems and the database appears to be
corrupt. I try to run Compact and repair in Access and Access either crashes
or hangs. Ive installed the latest mdac and jet drivers. Anyone know how to
fix this problem?

 

[jmonty]

I would create a blank database.
On the Tables tab, click New, then Import.
Browse to the corrupted DB and select all tables, forms, queries, reports,
etc.
Always remember to periodically backup you database.
Lesson learned the hard way.


jmonty