Question??

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have an Access application which was splitted into front-end and back-end
design. The back-end of it is installed on a server. Recently end-users
complained that records dissappeared from the application. I did some
trouble-shooting on the front-end and found no fault in the design that will
delete data from the table. I wonder if it is possible to track any records
deleting from the back-end and perhaps have a log table to store some
information in it. I want to track the date and time and user name in that
table. The appliaction was designed for the Order Entry which has the
Product table, Order table and Order Details table and several lookup
tables. Order and Order Details are in one to many relationship with cascade
update and delete i.e. when user delete OrderID and it will delete all
related records from the Order Deatils table. Users said OrderID disappeared
with no reason and they did not deleted it themselves. Thanks.
 
If you don't have RI enforced, records can "appear" to be deleted because
they end up with missing or invalid values in their foreign key fields.
Also, use LEFT joins in all queries against many-side tables that may not
contain a row for the one-side table.
 
Back
Top