Accessing a secured database objects from a VB application

[Newman]

Hi!

I try to access a secured database from a VB application. I know how to do it on an non-secured database, but when I secure it, I get nailed!

The thing I really need is the connection string, including where to include the username and password.

I use an Access 2000 database and a VB6 application. I try to connect with ADO to execute a macro or a query in the database. I have good programmation skills, so don't worry to give a lot of details!

Thanks a lot!

 

[dcx693]

I have good programmation skills, so don't worry to give a lot of details!

Ah, but do you have good search skills!

How to Use the OpenDatabase Method to Open Password-Protected Databases
Automate a Secured Access Database Using Visual Basic
Open an Access Database with User Security

 

[Newman]

Ah, but do you have good search skills!

How to Use the OpenDatabase Method to Open Password-Protected Databases
Automate a Secured Access Database Using Visual Basic
Open an Access Database with User Security

Got me there!

 

[LaBelette]

Got me there!

Newman, you're disapointing me

 

[Newman]

That is very funny LaBelette.
Even more, knowing that it is you who wrote the first post using my connection.
Not sure I will let you use my computer again.
Keep on working instead of laughing at me.

 

[Banana]

A bit stumped on the OpenDatabase method.

It seems that it works if I set a database password, but that's not the case. No database password has been set for my secured database; the password dialogs are strictly user-level, not database-level.

I log in as the owner of the secured database, and try to run secured database from another database, only to get a message saying that I do not have the necessary permission to open the database, despite that I'm logged in as the administrator of the secured database (MDW is global, no?).

Any suggestions?