Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Maximum Access Database Size
- Thread starter Lukey
- Start date
dannyocean
Technical User
You have problems when you approach a gigabyte of data. I reashed that with about 1.2 million lines of data.
Access 97 has a file size limit of 1 gigabyte. I think Access 2000 goes up to 4 gig, but I'm not sure. It's easy to get around the limits, anyway. All you have to do is split the data tables up into separate databases, and link them to your front end. That works pretty well, from my experience.
In any case, I think you're better off if you keep it to about half that size. You may have problems if you get too close to the limit.
In any case, I think you're better off if you keep it to about half that size. You may have problems if you get too close to the limit.
- Status
Similar threads
- Locked
- Question