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.

have you done a compact and repair recently?

I will like to know if access can store a lot of data.

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.