Need help with Access Database size over 1 gigabyte

[freejack]

I have an access database that grew to 1,048,976 kb or 1gb. I am unable to open the database or compact or repair. Access is reporting that it is not a database file anymore. I know that Access has the 1gb size limitation. How can I open the database so that I can compact it or delete some records? Is there another utility that I can use? Will importing it into SQL help?

Any ideas will be helpful. Thanks.

 

[kranky]

What is the exact error message? What version of Access? Did you search at support.microsoft.com yet?

 

[freejack]

Access 97 and 2000. Upon opening the database, Access says it needs to repair the file. Upon repairing the file, Access says it is not a database file. Upon compacting the file, Access says it is not a database file.

 

[JW]

I've got a few Access 2000 databases that are pushing around 1.5GB. Access 2000 .MDBs can get up to 2GB.

Have you tried to import the objects into a different database?

Check this link on MS support for more help.
Damaged ACC2000 database

-jw

 

[Jack Abbott]

It's an old thread, but still in search. There's a blog I've bookmarked. It has many useful posts including this one - http://wordpress.semnaitik.com/2013/07/17/repair-access-database-manually/

The above post contains some useful information like how we can repair Access database manually, i.e. without using any 3rd party paid tool. Those Access users who are looking for free solution, must read this blog post once.

 

[LTC8K6]

A 16 year old necro for that?

Are you sure that's not just spam?