records in ms access 2000 ramdomly being deleted

A

allan

we're using access 2000 and vb6 under winxp

We have a program use for sales. Every afternoon the users send their
transaction data for the day to our main office.

The weird thing is... if they have 20 transactions for the day, those
records where sent to main office (and its uploaded in our sql table). The
next day the users open the program, the 20 transactions were no longer in
their table.

Users don't have access to delete the transactions.

Thanks in advance
 
A

Arvin Meyer [MVP]

allan said:
we're using access 2000 and vb6 under winxp

We have a program use for sales. Every afternoon the users send their
transaction data for the day to our main office.

The weird thing is... if they have 20 transactions for the day, those
records where sent to main office (and its uploaded in our sql table). The
next day the users open the program, the 20 transactions were no longer in
their table.

Users don't have access to delete the transactions.
Click to expand...

Someone must have had access to delete the records. It is possible that the
records were deleted in code, but someone must write and execute the code. A
day's worth of data doesn't just disappear.
 
Top