Auto Database Login 1

[anujkmehrotra]

Hi,

I have BE (pwd secured), but i have to login it every time when i open it. i set a fixed database password "Password" in it, so i want it to open automatically when i open it directly not from FE, but when someone tries to import or Link BE, it should ask database password.

Can anyone tell me that is there any code or way to login automatically (Database Password) BE while opening it?

Thanks & Regards,
Anuj

 

[MazeWorX]

for Access 2002-2003 and earlier you can use a command line switch to supply the password
Shortcut example:

"c:\program files\microsoft office\office12\msaccess.exe"  "c:\My Folder\My Database.mdb" /pwd password

see

http://support.microsoft.com/kb/209207

for a full listing of switches

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[anujkmehrotra]

Thanks dear.

Thanks & Regards,
Anuj