I will like to know if access can store a lot of data. I am using a database that was written in access and the database has been in use since like 2004. How long can we still use this database. It is becoming slow and having one or two error messages.
Access size
- Thread starter kasa74
- Start date
CraigDolphin
GrumpyOldMan in Training
- Local time
- Today, 06:30
- Joined
- Dec 21, 2005
- Messages
- 1,578
Well the answer is yes. For example, I have a db with over 50,000 water quality observations and all associated peripheral information that is only 13.5 Mb (including forms etc). I understand that Access can grow to a size of ~ 1.5 Gigabytes before you start running into file size issues.
Make sure you compact and repair regularly to eliminate file bloat. If your fielsize following a compact and repair is close to 1.5 Gb then you either have to reduce file size (if you haven't already, learn about table normalization to vastly improve file storage efficiency), split tables into separate database files and link to the tables, or look into other database options like SQL server, Oracle, etc.
Similar threads
