ASK : How to connect VB6 to MS Access database?

Discussion in 'Programming' started by so_sweet, Jan 18, 2010.

0
  1. #1
    Hi there..
    just a lil bit problem, how to make a connection between VB6 and MS Access database? with username and password entity :D

    thanks
     
    so_sweet, Jan 18, 2010 IP
  2. NeoCambell

    NeoCambell Peon

    Messages:
    456
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Use the following connection string.

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;
    Code (markup):
    In the following link you will get the whole set of MS Access Connection Strings.

    MS Access Connection Strings
     
    Last edited: Jan 19, 2010
    NeoCambell, Jan 19, 2010 IP
  3. ryantetek

    ryantetek Peon

    Messages:
    42
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Or use the ADODC component...
     
    ryantetek, Jan 21, 2010 IP