Setting default username and password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have user level security already set up on my database. But I was
wondering if there's a way to define the default username and password when
the database starts up? I don't want the application to ask users to log
in...it should only ask for username/password when the user wants to see the
database window...

Is there any way to do this?
 
I have user level security already set up on my database. But I was
wondering if there's a way to define the default username and password when
the database starts up? I don't want the application to ask users to log in...
Click to expand...

Create a desktop shortcut for each person with the following syntax:
"<Full path to msaccess.exe here>" /User"UserNameHere" /Pwd"PasswordHere"
"<Full path to file here>" /wrkgrp "<Full path to workgroup file here>"

That should all be on one line.
Enter the User Name and Password that you want each person to
use in the appropriate spot.
....it should only ask for username/password when the user wants to see the
database window...

Is there any way to do this?
Click to expand...

No, that is not possible based on your specific requirement.
You would need to show the database window through another way.
 
Thank you for your help. This might just work...just one question...where do
I insert this line of code? Is this the value for "arget" or "start in"?

Parveen
 
Thank you for your help. This might just work...just one question...where do
I insert this line of code? Is this the value for "arget" or "start in"?
Click to expand...

It should be in the Target area.
The exact syntax with correct spaces must be entered or it will fail.
The user will not be prompted for a user name/password by
double-clicking the link if done properly.
 
Yes this worked! Thank you! :) Is there anyway to hide the location of the
database from the user?
 
Yes this worked! Thank you! :) Is there anyway to hide the location of the
database from the user?
Click to expand...

Excellent, glad you have it working.

Hide the database from the user?
You could put it in a hidden folder on a server perhaps, but I think
it will still show in the Target area of the shortcut.
 
Jeff Conrad said:
Create a desktop shortcut for each person with the following syntax:
"<Full path to msaccess.exe here>" /User"UserNameHere" /Pwd"PasswordHere"
"<Full path to file here>" /wrkgrp "<Full path to workgroup file here>"

That should all be on one line.
Enter the User Name and Password that you want each person to
use in the appropriate spot.


No, that is not possible based on your specific requirement.
You would need to show the database window through another way.
Click to expand...
A possibility is to use dao.workspaces to check for user/group.

However, it may be that you only need to have a table (hidden?) with a
secret squirral password. Then have a form displayed to give the user a
chance to try their luck at guessing the password. A successful attempt then
goes to the next level.

Luck
Jonathan
 
Back
Top