User Permissions in Access

[arg...@yahoo.com]

I want to have a group of users in Access who will have only the
ability to view tables and run maketable queries to update tables. I
don't want them to have the ability to modify certain tables within the
database.

What's the best way to do this?

[Arvin Meyer]

Set up user-level security. Have a look at this KB article. Read it
carefully several times before starting to implement:

http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

<arg...@yahoo.com> wrote in message
news:1116356483....@o13g2000cwo.googlegroups.com...

[Jeff Conrad]

"Argniw" wrote in message:
news:1116356483....@o13g2000cwo.googlegroups.com...

> I want to have a group of users in Access who will have only the

Access User Level Security is what you need for this situation.
It is, however, a difficult concept to grasp and implement properly
the first couple of times. Read all the of the following material I
have accumulated here and practice on dummy databases.

http://www.ltcomputerdesigns.com/JCReferences.html#Security

Good luck,
--
Jeff Conrad
Access Junkie
Bend, Oregon