user accounts

G

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?
 
A

Arvin Meyer MVP

gator said:
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?
Click to expand...

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
 
G

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.
 
A

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
 
Top