Member Avatar for Nicholas Ng

i want to ask some question ???

Dim conConnection As New ADODB.Connection
    Dim cmdCommand As New ADODB.Command
    Dim rstRecordSet As New ADODB.Recordset

        conConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\Documents\Visual Studio 2008\Projects\trial database\Microsoft Office Access 2007 Database.accdb""
        conConnection.CursorLocation = ADODB.CursorLocationEnum.adUseClient
        conConnection.Open()

im using visual studio 2008 ,i want to access to mirosoft access 2007 database...is this the way to open the database??
got the way to access the mirosoft access by not using the AdODB and just straight connect by coding ?? the code is how 1 ??

Edited by peter_budo because: Adding code tags to old post
  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

USE ADO.Net providers - System.Data.OledDb.

...
Dim Cn as New  OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\csnet\Database1.accdb")
cn.Open()
cn.Close()
...
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.