ADODB

[urs]

hi
i am trying to open an password protected Access 2000 Database using ADODB . i am getting an error
"Cannot Start ur application.The work group information file is missing or opened exclusively by another user" but i am sure nobody is using it this is my coding

Dim db As New ADODB.Connection
Dim rd As New ADODB.Recordset
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;User Id=Admin;Password=cool;Data Source=D:\cool.mdb;Persist Security Info=False"
rd.Open "Select * from saf", db, adOpenStatic, adLockOptimistic
Text1.Text = rd.Fields(0).Value

i searched previous question realted to this 1 guru had suggested to user "Pwd" instead of "Password" in the connection string which is also giving me an error
"Cannot find installable ISAM"
plzz help me
thanx

[Cimperiali]

>Cannot find installable ISAM
you sure you have Microsoft.Jet.OLEDB.4.0 drivers?
May be adding an Adodc1 on a form and using its options to build the connection string (and testing it) may help....

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Micahel
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

[urs]

yes i do have "Microsoft.Jet.OLEDB.4.0 drivers"
cause when i tried to open a database without password it was working fine without any errors

[urs]

Even Adodc1 is giving me the same error
Cannot Start ur application.The work group information file is missing or opened exclusively by another user

[Cimperiali]

then call task manager (if on winnt) and look at opened processes. Maybe something is not closed. In case, simply restart your machine. Maybe you've forgot to close or set to nothing some referencing variables...

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Micahel
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

[urs]

no this is not possible cause i havent opened this database for 2 days