PROTECTING TABLES

  • Thread starter Thread starter sam1967
  • Start date Start date
S

sam1967

Is it possible to give one user access to a table and deny that access
to another user of the database ?
 
Yes, if you implement User Level Security. Read the Security FAQ from
Microsoft. There is a link to it on the Security page of my website.
 
Then re-read it a few times very carefully. Try it out on a test
database first. You can lock yourself and everyone else out if you don't do
it right.

I don't want to scare you from using security, just make sure you do
understand it however. It is a great tool. Screw it up an no one can help.
 
Yes, if you implement User Level Security. Read the Security FAQ from
Microsoft. There is a link to it on the Security page of my website.

OK. I set it up but Users with no permissions can still create new
tables. I know this is a bug/feature of Access from a previous post on
the sublect. Apparently the only way to prevent a user from creating
obejcts is to hide the menus etc.
how would I go about doing this ?
 
OK. I set it up but Users with no permissions can still create new
tables. I know this is a bug/feature of Access from a previous post on
the sublect. Apparently the only way to prevent a user from creating
obejcts is to hide the menus etc.
how would I go about doing this ?

Sounds like you missed item #24 in the FAQ - How can I prevent users from
creating new objects in my database?
 
Back
Top