Password on Tables and Queries in Access 2003

N

NewUserToAccess

Hi,

I am a new to Access. I am using Access 2003. I was wondering if there is
a way to put a password on specific tables and queries. I know there is a
password security in Access, but I believe its for the entire database. Just
curious if we can have one password setup for certain tables and queries.
Thanks in advance.
 
D

Douglas J. Steele

It's an all-or-nothing proposition.

You could apply user-level security, and set permissions differently for
some of the tables than for others, but that would require that each user
log into the application up front, as opposed to being prompted when they
want to use the specific table(s).

If you're interesting in pursuing the user-level security option, check out
http://support.microsoft.com/support/access/content/secfaq.asp

It's not a simple undertaking. Make sure you read the FAQ thoroughly several
times, work on a copy of your database (just in case!), and make sure you
don't leave out any steps.
 

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
Table Security in Access 2013 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Adding data to MS Access from csv file 0
Problem in securing data base 1
Access 2007 requires password to open Access 2000 database 0
MS Access 2007 - Database Password 0
Different passwords in Access 2007 5

Top