-
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?
-
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 [email protected]
Ph +61 3 97958156
Fx +61 3 9795 8156
http://www.users.bigpond.com/jimp/index.html