how to setup password control to specific tables in Access?

B

BUZZWORKZFX

I am trying to set up user level accounts that have password access but only
to the content of specific tables in Access 2003 - would really like the
access to initiate on a switchboard.
 
J

Joan Wild

That is quite doable with User Level Security. The permissions you grant to
the Users Group will be available to any user that doesn't login, and you
can protect specific tables to other users.

You can set a startup form (your switchboard) in Tools, Startup.
 
B

BUZZWORKZFX

Ms Wild,
Thank you - I did not see where I could assign specific tables in the User
level setup - will look deeper.
Thanks again,
BUZZWORKZFX
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
List all tables, including document structure 0
Table Security in Access 2013 1
Creating a Chart on form from selected data in query. 0
Password Protection 1
How do I clear a form? 0
Problem with the account passwords of MS Outlook 2007 0

Top