hi,
this problem has been borthing me for a long time, here is what happen:

for ex:
item code: ac-1010, qty is:10
today i update it to qty: 8 after some sales and I am so sure the data is updated.
(qty database is 8 and history database is also record the process)

but after a while, the qty will go back to 10 like the sales never happen.
(qty database rollback to 10 and history database has no such record)

please help~

This hasnt happened to me yet, and I use access every day..

Is your database open read-only or something?

of course have to open to write when updating, and i did close the connection when update is finished.