ODBC connection from VB5

[Ely]

I'm in a very strange situation. I made a program in VB5, and built a database for it, that it uses, in Access97.
Now, I don't want anyone to be able to access the database outside the program, so I set a password for opening the database.
When I'm trying to open it with VB5, giving it the password through the ODBC connection, it won't receive it.
What can I do?

[JeremyP]

Check your connection command line. It sounds like you havn't conencted to the datasource correctly through ODBC.

Try this line of code, but change it to your needs:

dbpde.ConnectionString = "DSN=PDE;DATABASE=PDE;UID=admin;PWD="
dbpde.Open

DSN - DataSource Name
DATABASE - Database File Name
UID - User ID
PWD - Password

Give it a go.


------------------
Jeremy Powell
Powell Consulting Services Pty Ltd
Australia
EMail jeremyp77@hotmail.com
Ph +61 3 97958156
Fx +61 3 9795 8156
http://www.users.bigpond.com/jimp/index.html