DB Size

[Barry]

Hi

Is there a limit on the size of an MS Access Database, one of my Databases
has stopped accepting records after the size reached 2 GB.

Note: i have posted this again, as the original posting was done on the
wrong forum.

TIA
Barry

 

[Wayne-I-M]

Open access and use F1 then search specifications.

IMO - a 2gb DB is not what access is meant for -

 

[Klatuu]

2 gig is the file size limit for an mdb or accdb file. But, if you have
reached that limit, you are likely doing something wrong.
Is your database split? That is, do you have the data in one and all the
application objects(forms, reports, macros, modules) in another? If not, it
should be.
Are you embedding pictures or other graphic objects in the database? You
should not. If you want to include such objects in your application, you
should define a folder to store them in and use either a text or hyperlink
field to store a path to the objects.

First, try to compact and repair your database, then correct the problems
described above.

I have databases with a lot of data that are a lot smaller. For example, I
have one that has 59 tables with record counts ranging from 9 to 1,963,046
records that is 793,636 KB. So, when you hit 2 Gig, either your applicatoin
needs to be upsized, or you need to address the issues above.