delete log in backend database

[benniesanders]

hi all,

i have a backend access 2003 database used with a frontend database also in access 2003. I have 14 users and am working on a new version of the frontend, but I'm not ready to launch it yet. Problem is, somebody is deleting records and I need to find out who or stop them before than can. Is there a way in the backend database where I can stop them before a record is deleted or at least capture the user who is deleting the job? In my new version I have a password protected delete button but I'm not ready to give them the new version yet and I really don't want to modify the old version and copy it out there 14 times. Any ideas would be appreciated. Thank you!

 

[psemianonymous]

Please make sure you turn off the "can delete items" option on the Form Properties, otherwise your delete button won't be stopping anything as they can still delete using the other 9 out of 10 ways to delete.

The other thing you can do is use the Form_Delete() event and cancel it by default.

Also maybe they're deleting things from the table view itself (unlikely), but if that's the case--you'll have to think something up.

 

[SeeThru]

I've got delete turned off in all my forms as above - the only way to actually remove them is by query or table view.

 

[benniesanders]

Thanks all. I was hoping I wouldn't have to change anything in the front end. That was my delimna. But I ended up rolling out the new version ahead of schedule, so it's a non-issue now. Thank you again very much for your input!! :