Access Login

[Guest]

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.

 

[Douglas J. Steele]

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.