ADO

I'm trying to access a password protected database through VB.
I added a Microsoft ADO Data Control to my VB project.
I attempt to connect to the database after creating a connection string and setting all the right properties but I get and error which reads:
Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
The database isn't open as far as I know and the password is right.
Any ideas?

-cl

As far as I know you can not directly open an Access Db via ADO which has security "enabled".

The Username and Password must be typed into the Access Security login screen.

I'm not too knowledgeable on ADO but I do know DAO and you can do it that way. If you wish I can send you some code.

Later.

Quote of the moment....
"When you cease to make a contribution you begin to die"