Anybody know the .opendatabase command series to open a database with a password?
Printable View
Anybody know the .opendatabase command series to open a database with a password?
I share your problem!!!
I have posted the same question, but no luck yet.
I couldn't figure it out.
Hope somebody out there knows.
have a nice day.
you will need two lines similar to these...
Set DB = OpenDatabase(App.Path & "\Alert.mdb", False, False, ";PWD=password")
Set RS = DB.OpenRecordset("Errors", dbOpenDynaset)
This should do it..
let me know if you have any further questions.
[email protected]
it worked. Thanks.