Database has reached maximum size Error 3036 1

[mfd777]

My database has reached 1 gig. This happens during an import routine. I know that after I compact that the size will reduce to 450MB. Is there a way of incresing the maximum size limit of an access '97 database ?

 

[JerryDennison]

I'm surprised you're not getting all kinds of complaints for slowness. While Access supports databases of this size I've found that anything over around 300mb is not very efficient. I'd recommend you consider migrating to SQL Server or some other higher end RDBMS system.

 

[Lightning]

Unfortunately , there is no way that I know of to increase the max size limit of Access dbs. But here are a couple of ideas to try and get around your problem.

Are you imnporting one table or several tables? If it is several tables, try compacting the db between some of the imports.

You could also try importing the data to another (empty) db and linking the table(s) to your origninal db.

HTH
Lightning

 

[Francescina]

There is no way to increase the maximal file size but you might upgrade to A2K to double this value.
I recommend to import the data into an empty MDB, compact it and integrate the data in to the "real" MDB.
If the file still gets too big then you need to split the data that will be imported in several blocks.

Good luck!