you should create a workspace by using the CreateWorkspace methos of the DBengine object there you specify the user & password and the use the OpenDatabase Method on that workspace ,or you can use the Defualt Password and Defualt User properties of the Dbengine object.
good luck
Danny Ravid
Quote:
> Anyone know how to open a password protected Access97 Database in VB5 > What is the connection string?
> Thanks
Fri, 14 Jul 2000 03:00:00 GMT
Alex S #2 / 3
Opening a password protected Access file
Anyone know how to open a password protected Access97 Database in VB5 What is the connection string?
Thanks
Sat, 15 Jul 2000 03:00:00 GMT
Jim Fergus #3 / 3
Opening a password protected Access file
Quote:
>Anyone know how to open a password protected Access97 Database in VB5 >What is the connection string?
set db = dbengine(0).opendatabase("yourdb.mdb",false,false,";pwd=yourpwd")
Opening a password protected Access file