cant open my database !!

[TRYP]

Dim x As ADODB.Connection
Set x = New ADODB.Connection
x.Provider = "microsoft.jet.oledb.3.51;"
x.ConnectionString = "persist security info=true;" & _
"Data Source=a:\myvbproject\school2.mdb"

x.open ,,password

I get an error that says something about a workgroup file cant be found or is in use

ive opened databases before just never one with password before.
Any Ideas ?
-tryp

 

[veronica]

Hello, try to change your code with that connection string:

Dim x As ADODB.Connection
Set x = New ADODB.Connection
x.Provider = "microsoft.jet.oledb.3.51;"
x.ConnectionString = "Persist Security Info=False;Data Source=a:\myvbproject\school2.mdb;Jet OLEDBatabase Password=YourDatabasePassword"
x.open

Bye, My e-mail is: vzudaire@yahoo.com