Quick & Easy Access/VB question

[elziko]

In access I went to Tools|Security|Set Database Password. I gave it a pass word.

Fine.

But in VB(ADO) what username to I give to connect to the database? "Admin" does not seem to work!

Thanks

elziko

 

[Phathi]

Leave the username field out (blank)

 

[elziko]

Then it just complains that the username/password is wrong but I'm sure the password is correct. I'll try again!

 

[elziko]

Oh just tried it again and I must have miss-typed! But now I get a new error:

Can't start your application. The workgroup information file is missing or opened exclusivly by another user.

Its not the latter so what would one do about the former?

Thamks

elziko

 

[VBXL]

Try opening up the database in exclusive mode

Xplain

 

[Phathi]

The only way you can insert a password into access is to open the db file exclusively.

This blocks off any other interaction until you close the file.

So, make sure you close access before you try run from VB. If you want to open both, make sure Access isn't opened exclusively

 

[mikhailwaxman]

In ADO Property Sheet go to
Conection Tab
UserName:Admin,
Password: (blank).
Click Tab "ALL" and Edit "Jet OLEDBATABASE PASSWORD". Put your password here. That's all.