VB-Access

[Jayachandra]

Hi everybody,

I have taken Access as Backend for VB . I set a password to the access file. But when i run the application it is giving an error. How to set the password in the VB 6 in coding. in Connection String. please help me in this concept.

Thank in advance.
bye

[r035198x]

Hi everybody,

I have taken Access as Backend for VB . I set a password to the access file. But when i run the application it is giving an error. How to set the password in the VB 6 in coding. in Connection String. please help me in this concept.

Thank in advance.
bye

Do not post questions in the articles section.
Moved to the forum.

[ansumansahu]

Hi everybody,

I have taken Access as Backend for VB . I set a password to the access file. But when i run the application it is giving an error. How to set the password in the VB 6 in coding. in Connection String. please help me in this concept.

Thank in advance.
bye

Hi ,

This is how you define the connection string.
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

good luck
-ansuman sahu

[debasisdas]

Please find the details regarding connection string here .

[Jayachandra]

Thank you for Reply,

Here I am using ADODB.connection

How can I open my Access Database which is having password set by Exclusively. while trying with dbOpen.Mode it is not appearing in the list for ADODB connection.

Thank you

[sumitbatra1981]

User id will be admin
password will be the one u set tou your access file