Prevent deletions of records from tables?

[markmarko]

I would like to prevent anyone from deleting records from tables. I see ways
to prevent deletions via forms, but I'd like to make sure that if someone
went into tables directly (they shouldn't be able to since most (if not all
users) will be using Runtime, not full Access. But nevertheless, I'd prefer
to make sure no records get deleted ever (unless I delete them personally.)

 

[Chris]

AFAIK, the only way to accomplish what you want is to prevent the end user
from having direct access to the tables (if you follow best practices, you
only allow end users to use forms and reports to view the data any way).

 

[Allen Browne]

You will have to set up Access security (MDW) to achieve what you want.

One problem with this approach is that MS has dropped security from A2007.
Therefore you may be heading down a dead-end path for the future.

Setting up security is not difficult, but you must follow the steps
precisely. Here's the detail you need:
http://support.microsoft.com/kb/207793/en-us

Other resources:
http://msdn2.microsoft.com/en-us/library/aa679809(office.11).aspx
http://www.vb123.com/search/toc.htm
http://www.access.qbuilt.com/html/how-to_tips.html
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

 

[markmarko]

Well, I'm using Access 2007 now, so I already don't have that built in
security.

Thanks for the information, much appreciated.

 

[Allen Browne]

If you don't mind the fact that this is a dead end, and if you are using the
old format (MDB, not ACCDB), you can still get there by using expressions
like this:

RunCommand acCmdWorkgroupAdministrator
RunCommand acCmdUserAndGroupAccounts
RunCommand acCmdUserAndGroupPermissions
RunCommand acCmdUserLevelSecurityWizard