Protecting A Table

Keith Burgess

Registered User.
Local time
Today, 16:42
Joined
Aug 10, 2006
Messages
26
Hi There,

Can anyone tell me a way of protecting the data stored within a table, so that users cannot inadvertently change or delete data from it???

Best Regards
Keith:(
 
A table is like a will, someone that shouldn't will get into it.

You can hide the table, set read-only permissions, hide that database widow so that it's not accessible, setup security permissions.

Make the table accessible only through a form (hide the database window, as well as the means to make it visible except for a "back door" for you) and make it non-updatable through the form by setting the following form properties to "no:"

Allow Edits
Allow Additions
Allow Deletions

Someone with still try to get into it.
 
still there is a problem??

Fine, but how about linking tables from another database???
 
A native Access table in an mdb is a table, whether it is linked or not.

Of course, SQL Server and Oracle tables are different, although you also can set .many of their subject attributes.
 
I mean how to deny

What I mean is how to deny linking to the tables and changing values?
 
your best option would be to have all users log in under user names (not admin), add a password to the admin account that only sysadmins know and set the permissions for the table so that admins have total control and non-admins have no control.
 

Users who are viewing this thread

Back
Top Bottom