Connect Access table to VB6 application

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lita
    New Member
    • Jul 2007
    • 4

    Connect Access table to VB6 application

    hello....I am a new member and I hope you can help me to solve my problem. I am using VB6.0 and I want to link with the MS Access table. I done everything like creating the table and set all the object in the VB interface but the only thing left is the coding part pliz can someone help me out with the coding....
  • slapshock
    New Member
    • Oct 2006
    • 57

    #2
    Originally posted by lita
    hello....I am a new member and I hope you can help me to solve my problem. I am using VB6.0 and I want to link with the MS Access table. I done everything like creating the table and set all the object in the VB interface but the only thing left is the coding part pliz can someone help me out with the coding....

    Try this code:

    con.open "Provider=micro soft.jet.oledb. 4.0; datasource=data base name"
    rs.open "select * from tablename",con, 3,3

    connection complete
    Happy Coding

    Comment

    Working...