I have a large Access 2003 table with about 1.2 million records; it has only about 6 fields, none of which are memo type. Today we noticed that some records are missing. They were there in the table yesterday, but not today.
not much you can do after the event, it is possible that (some of) your users have deleted data on the quiet.
If you run an audit log then you can find out how did what and when
if you design your forms & switchboard appropriately then you should be able to control who has access to your data and what actions they can do (ie users group X can eneter , but not delete data, group Y can change, but not add, group z can do what ever). I'd still want to run an audit log though.
Mind you at 1.2 million records its geting a bit of a handfull for Access isn't it.
Yeah, I would believe users error over lost data too, except users aren't allowed to delete from that table, unless they went through the back door. I know Access isn't meant for so many records, but the Access database was a "temporary" database that's been going for over two years. Just a few more weeks and it'll be moved out of Access.