user accounts

[gator]

If I need to copy a database to a few computers and I have set up users in
the database....how do I apply a certain user to a certain computer?

 

[Arvin Meyer MVP]

If I need to copy a database to a few computers and I have set up users in
the database....how do I apply a certain user to a certain computer?

Depending upon the version, you can use User Level Security and ensure
though the login process who has rights to what. You can also use the
Windows information:

You can get the Machine name with this code:

http://www.mvps.org/access/api/api0009.htm

and you can get a username with this code:

http://www.mvps.org/access/api/api0008.htm

 

[gator]

can't i assign usernames and passwords for user accounts in a particular
Access database? I have been able to set up users but I can't figure out how
to set up passwords. Then, when I load a database on someone's
machine...tell that database which user to use.

 

[Arvin Meyer MVP]

Yes you can in version 2003 and earlier, using User Level Security: Here is
everything you might want to know about it:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm