My database which is currently
29MB is continually losing records,
any ideas as to what the problem might be?
To eliminate the possibility that some user might be accidentally or
maliciously deleting records, or that there's some code inadvertently doing
so, remove all users' delete permissions on the tables involved.
There could be many causes: bugs (to lower this probability, make certain
you are up to date on Service Packs for Access and for the Jet database
engine), code errors, user action, database corruption, etc..
We had a recent report in one of the newsgroups: seems a client was having a
similar problem, the developer took "Step One" and, surely enough, it wasn't
long before one of the users came around to ask what was wrong with the
database -- it isn't working right.
