1

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: Adding code tags to old post

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by __avd
0

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()
...
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.