Help! Corrupt database too big to compact?

[Nick]

I have a database that has reached over 1 gig in size. I
was just trying to get by with it until I transfer it all
to SQL, but it has finally become corrupt. I can not use
the Access compactor because the file is too big and the
Jet Compactor doesn't seem to work. Is there any other
way to recover the data or to compact and repair?

 

[Bruce M. Thompson]

I have a database that has reached over 1 gig in size. I

was just trying to get by with it until I transfer it all
to SQL, but it has finally become corrupt. I can not use
the Access compactor because the file is too big and the
Jet Compactor doesn't seem to work. Is there any other
way to recover the data or to compact and repair?

Create a new, blank database and try importing your objects from the problem
MDB. You might want to import only a few objects at a time to help in
identifying any corrupt objects.

 

[Jim/Chris]

Try importing all objects to a new DB

Jim