How do I remove 'Delete Record' function in Access

  Radix Lecti 10:50 27 Nov 06

Morning all.

Would any techie out there advise how I can go about removing the 'Delete Record' function (in any of it's locations) from an Access 2003 database?

People having the ability to delete a whole lot of project work data really does make a mockery of the audit process!

Many thanks.

  Belatucadrus 11:07 27 Nov 06

I think you need to create some different user accounts with the Security Wizard, with an admin style account for yourself and either a "New data Users" or "Read Only Users" accounts for other people.
I'd strongly suggest backing up a copy and playing with the wizard to ensure familiarity before using it on the main database though.

  I am Spartacus 11:08 27 Nov 06

Setup User Groups and then setup permissions?

Tools, Security, User and Group Permissions

  Radix Lecti 11:43 27 Nov 06

OK, thanks for this... HOWEVER...

I've just discivered that the guy who set this thing up (no longer here) has the whole 'Permissions' feature setup using VB (which I'm very unfamilliar with).

I have found a reference in the VB, where some others buttons are made hidden, and it looks as though I need to find out the Cbar.Id for the 'Delete Record' button.

Anyone know how I can find this?


  Radix Lecti 12:57 27 Nov 06

Ok... I've managed to get the Delete button hidden, so that's good.

I now need to disable the 'Unhide...' option under 'Window'. I'm going to have to go the VB route (and not the build in Permissions route).

Anyone know where I can find the Cbar.ID for this option?

This thread is now locked and can not be replied to.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…