Reading a .mdb file with VB6

How can I read a simple .mdb file with VB6 that is password protected. All user permissions are set to default and I can read it fine if there is no password without using any code. When I add a password to the Access database, my VB app can't access it anymore. Any ideas??
Albert
LVL 23
ahammarAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
AjoyConnect With a Mentor Commented:
ahammar,
u can set up a connection string with  the userID and Password.
Then set up the conection to the database with this connection string.this should work.
eg:
dim sCnn as string
scnn = "{rsDbdriver}, ServerName,databasename,TableName,UsrID Password"
use this string(scnn) to establish connection  with the .mdb file
regards,
ajoy

my mail ID is :
Ajoy.Tarafder@in.bosch.com
u can mail me at the address mentioned and i will try to help u out

0
All Courses

From novice to tech pro — start learning today.