PROTECTING TABLES

[sam1967]

Is it possible to give one user access to a table and deny that access
to another user of the database ?

 

[Lynn Trapp]

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.

 

[Joseph Meehan]

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.

 

[sam1967]

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 ?

 

[Joan Wild]

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?

 

[sam1967]

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

ah you got me there. i didnt read that far .