ADO Link to DB with Password

[mderby]

Hi all,

I want to link to a table in an Access DB with DB password. I wish to use ADO to accomplish that but unfortunately there is error in my open connection declarations. The errors state :

"Run-time error '-2147217843 (80040e4d)"
Cannot start your application. The workgroup information is missing or opened exclusively by another user.

Check that no one is accessing the DB.

The connection string is as below.

myconn.Open ConnectionString:= _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "C:\MS Trial Access\TimeMgmtSec.mdb",_ UserID:="admin", Password:="gfsap3"

Please advise.

Thanks a lot beforehand.

mderby

 

[Shadez]

what type of password is it,

1) DB password

2) username / Password

the string is different for both

 

[Shadez]

Db passwords

=

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SomeDB.mdb;Persist Security Info=False;Jet OLEDB:Database Password=TheDatabasePassword"

Will post the username and password code if you need it.

note the is ment to be : D without the space

 

[mderby]

Thanks

Hi Shadez,

Thanks for your help. It works now. Seems like
I will need to brush up my ADO skill.

Any good link or book to recommend ?

Cools. Btw i kind ah like that smili in that words

OLEDBatabase

Bye.

 

[Shadez]

Soz cant help on a book,

i would of thought by coding the line it wound not of changed : D to