In my split dabase, which is used by 15 persons, the backend's main table
suddenly misses 4000 records in comparison to last night's backup. I have
never seen this before. I checked for corruption but didn't find anything. I
repaired the db but no change. The missing records seem to be deleted
randomly, I analysed the missing records but can't find a deletion pattern.
Maybe a user went into the backend and did a deletion by accident.

Has anyone experienced something like the above? Any ideas what could have
caused it?

Thanks, Martin

<martin (AT) hotmail (DOT) com> wrote

Martin.
Unless you have a query or procedure in the front end which deletes records,
I think that your suggestion that a user has accessed the backend is most
likely.
I recall posting a similar message here some years ago, and no one could
come up with another answer.
I try to prevent users from accessing the backend for this type of reason.
Having said that, it probably wouldn't stop a determined 'sabateur'.


--
Bob Darlington
Brisbane

Thanks for your reply Bob. Good idea to put effort into preventing users
gettting into the backend.

Martin

"Bob Darlington" schreef in bericht
news:4de41fdc$0$22470$afc38c87 (AT) news (DOT) optusnet.com.au...

<martin (AT) hotmail (DOT) com> wrote

Martin.
Unless you have a query or procedure in the front end which deletes records,
I think that your suggestion that a user has accessed the backend is most
likely.
I recall posting a similar message here some years ago, and no one could
come up with another answer.
I try to prevent users from accessing the backend for this type of reason.
Having said that, it probably wouldn't stop a determined 'sabateur'.


--
Bob Darlington
Brisbane

You could implement a logon file that would capture each workstation name
and/or install an autoexec macro on the backend that just displays a message
and runs the "quit" command. (Hold down "Shift" while opening the backend
for maintenance).
-Ed

<martin (AT) hotmail (DOT) com> wrote

Thanks for the ideas. Will do so.
Martin

"Ed Robichaud" schreef in bericht
news:4dead4af$0$4022$2ff6ac69 (AT) news (DOT) wdn.com...

You could implement a logon file that would capture each workstation name
and/or install an autoexec macro on the backend that just displays a message
and runs the "quit" command. (Hold down "Shift" while opening the backend
for maintenance).
-Ed

<martin (AT) hotmail (DOT) com> wrote