2 Replies - 5912 Views - Last Post: 11 December 2009 - 07:44 PM Rate Topic: -----

#1 krishnaradha  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 10-December 09

access database connectivity in vb6.0

Posted 10 December 2009 - 01:37 AM

what is the code for access database connectivity in vb6.0
Is This A Good Question/Topic? 0
  • +

Replies To: access database connectivity in vb6.0

#2 no2pencil  Icon User is online

  • Toubabo Koomi
  • member icon

Reputation: 5230
  • View blog
  • Posts: 27,016
  • Joined: 10-May 07

Re: access database connectivity in vb6.0

Posted 10 December 2009 - 01:52 AM

access database connectivity in vb6.0

** Renamed title to be more descriptive : I would imagine that VB topics go under the VB forum (zomg!) **
Was This Post Helpful? 0
  • +
  • -

#3 cinor16  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 11-December 09

Re: access database connectivity in vb6.0

Posted 11 December 2009 - 07:44 PM

View Postkrishnaradha, on 10 Dec, 2009 - 12:37 AM, said:

what is the code for access database connectivity in vb6.0

use this one to connect to Access "Microsoft.Jet.OLEDB 4.0"

dbconn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Akin to\VB\employee\List.mdb;Persist Security Info=False"
dbconn.CursorLocation = adUseClient
dbconn.Open

rsdata.Open "select*(the file name of the Access Table)", dbconn, adOpenStatic, adLockOptimistic
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1