Passing the Password 1

[dotnetprogrammer]

I have a MS Access 97 database Macro that I need to run through my vb code. The file is password protected. Could anyone tell me how do I pass PASSWORD information to the MS Access 8.0 Object, so that the database will open without prompting for the password?
Thanks,
fred

 

[MikeCox]

I believe you can pass a password in with the connection string. Difference between a madman and a genius:
A madman uses his genius destructively,
A genius uses his madness constructively.

 

[VinceNL]

Hi,

To pass the password and userid you need to put them in the connection string. A nice way to do this is to create a file with extension .udl. Dubbleclick it and you get a wizard that makes the conn. string for you. Save it and open the UDL file in notepad.
And there's your connection string.

Good luck,
Vince