Access Database Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lance - 23 Jul 2006 04:23 GMT

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?

Reply to this Message

jmonty - 25 Jul 2006 18:06 GMT

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

> I have a website on a server running Windows 2000 Advanced Server.
> When I download the database and run Compact and Repair Database using
[quoted text clipped - 4 lines]
> or hangs. Ive installed the latest mdac and jet drivers. Anyone know how to
> fix this problem?

Reply to this Message