DB Password

Hi,

I've secure my database with an admin Password. Now i want to access the Database external via VB. How can i tell Access the password for the database?
I've tried the described method, putting the password in the connect property of the bound data control, but it doesn't work.

Any Ideas?

Hello,
If u use ADO and OLEDB to access Access DB, use the property "Jet OLEDB:Database Password" of the Jet OLEDB.

I'am using VB5 with the normal Data Control i'll bind it at runtime to an password protected Access Database. The Data Control does not have an property password

See the Connect property in the MSDN !

I put in the connect Property "UID=admin;PWD=test"

I've tried some other variations but i always get the Message "Invalid Password".
The Password was set directly in Access

Hi,

see answer on
http://members.tripod.com/smalig/vb/079913.html

Best Regards

Try the following:

Dim db As Database
pwwd = password.Text

Set dbs11 = OpenDatabase("c:\db.mdb", False, False, ";Pwd=" & pwwd)

I ran into the same problem you are and I went round and round with it. It didn't work for me until I set the Password equal to a variable then used the opendatabase method with the aforementioned arguments.

Hope this helps.

OK :-)

The result now is that i get the Errormessage "ODBC Connectio to Database xxx failed"

I don't know what i can do anymore :-(((