Access Login

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pool - 28 Oct 2004 21:39 GMT

Hi,
am converting access 97 to 2003 and have like 10 databases. i want to create
username and pwd for each person in the office so that they have different
permissions.

Q1. Can i have the same username and pwd for all for different databases
provided they have same permissions.
Q2. Can i associate the windows log in with the database security. I mean,
permissions should be decided based on there windows NT login.

Thanks in advance.

Reply to this Message

Douglas J. Steele - 28 Oct 2004 22:03 GMT

To use the same username/password, ensure you're using the same MDW file
when you secure each database.

Access does not support integrated security, so you cannot use their Windows
ID for security purposes.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> am converting access 97 to 2003 and have like 10 databases. i want to create
[quoted text clipped - 7 lines]
>
> Thanks in advance.

Reply to this Message