Security without log on

[Guest]

I am trying to use the window log user name as the access
DB user name, so users don't have to log on again. How
can I do it with Access? I am using Access 2000.

Thanks,

shirley

 

[TC]

Try the following very neat trick from david epsom dot com dot au:

Create a shortcut (all in one line):

"c:\msaccess.exe"
"c:\myapp.mdb"
/wrkgrp "c:\mywrkgrp.mdw"
/user %username%

This will start Access, automatically logging-on as the current user (as
determined from the environment).

Of course, change the file path names to match your own.

HTH,
TC