I've recently been experiencing "Lost" records in one of my tables. Please note that I am using a DB that was built for us before I began working with it and it has been modified NUMEROUS times throughout the years.

I am wondering if my recent problems could be caused due to the size of the table - with well over 70,000 records in the table it is making me quite nervous and I beginning to think I should split my DB into multiple copies to protect the integrity of the data.

Any thoughts?

Your Access database will store 2Gb of data. This can translate into 10's of Millions of records, depending on what data you are storing.

You can also, if you end up finding it necessary, can use a single database for one table and so on as a backend.

Also, is this database SPLIT (frontend / backend)? If not, it should be, with the backend on the server and a COPY of the frontend on EACH user's machine.

If it's any reassurance, I have a database that contains 4 million rows spread along four tables and only occupies 200-ish MDB. I've also seen other report even higher number of rows. So if you're experiencing data loss, it's not because of size, but rather due to other factors. Bob already gave you one possibility (e.g working on unsplit database shared with other users is a good way to create problems)