borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Next Topic (Milage calculator) New Topic New Poll Post Reply
AndreaVB Forum : VB General : Connect VB to Ms Access database with password
Poster Message
bluepiper
Level: Trainee

Registered: 22-10-2007
Posts: 1

icon Connect VB to Ms Access database with password

Im going to create a project with vb6 and ms access. I have to set password to open the DB for security. In vb6, how can i connect the database in data environment through data link properties setting the provider,database and the database password?? If i can do this, are there any posible problems that will occur when i create and call commands in data environment?? Please help me. I urgently need this. Thank you..  

22-10-2007 at 02:09 AM
View Profile Send Email to User Show All Posts | Quote Reply
Jihadalariqi
Level: Protégé

Registered: 18-12-2007
Posts: 6
icon Re: Connect VB to Ms Access database with password

if you use the ADO ,add  this string to connectionstring



Jet OLEDBatabase password=Your password



like this

con.Open "provider=microsoft.jet.oledb.4.0;Jet OLEDBatabase password=123; Data Source=" & App.Path & "\test.mdb"


____________________________
vbboy

18-12-2007 at 11:30 PM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
AndreaVB Forum : VB General : Connect VB to Ms Access database with password
Next Topic (Milage calculator) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder