Member Avatar for sweet_girl

hi ,
I need to know how can I connect Microsoft access with VB,I need to have wide space in programming in MS access...regards

  • 4 Contributors
  • 3 Replies
  • 128 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by abu taher
Member Avatar for dev_kc

Set Con = New ADODB.Connection
Con.Open "dsn=Datadb;driver={microsoft access driver(*.mdb)};dbq=d:\ABC\test.mdb"
Set rs = New ADODB.Recordset

Declare con and rs as public

Member Avatar for abu taher

you can connect it by properties. just put a data control and select its properties: connect database access and select the file location and then select the recordsource . all you by its properties.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.