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
"Lance" wrote:
[Quoted Text] > 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?
|