Access2K password from VB using ADO?

[softwareguy74]

Hi,

I'm connecting to a password protected Access2K database from within my VB app. I'm using ADO and the connect string is as follows:

goDb.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\something.mdb;Password=blablabla"

However, when I run it, and it attempt to connect to the db, I get the following error:

Run-time error '-2147217843 (80040e4d)':

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

I'm not using the workgroup security and the database is not opened exclusively, or opened at all for that matter..

Any idea what I'm doing wrong?

Thanks,

Dan

[cpradio]

Im stuck in the same situation. I have even tried a dozen methods of connecting to the database all which have produced the same error as you are receiving

[D12Bit]

You two might want to try this:

'If MDB has a database password
 
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mydb.mdb;" & _ 
           "Jet OLEDB:Database Password=MyDbPassword", _
           "myUsername", "myPassword"

[cpradio]

What is the difference between Database Password and MyPassword?

[cpradio]

module00conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                      "Data Source=" & FileName & _
                      ";Jet OLEDB:Database Password=admin;", "admin", "admin"

Here is what I have, it still produces the same error message.

[D12Bit]

let me turno on the other computer...on this I don't have VB

...

[D12Bit]

I was getting the same error...but now...I was able to get in...
like this:

module00conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                      "Data Source=" & FileName & _
                      ";Jet OLEDB:Database Password=admin"

I guess that the other two is when you got the usergroup working, anyway...i couldn't make it work with a system.mdw like file...

this should take care of your issue of accessing a passworded database...

[cpradio]

Thanks, that worked.