records in ms access 2000 ramdomly being deleted

[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

 

[Arvin Meyer [MVP]]

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.

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.