954,517 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Access Mirosoft Access 2007 in Visual Studio 2008

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 ??

Nicholas Ng
Newbie Poster
2 posts since Aug 2009
Reputation Points: 10
Solved Threads: 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()
...
__avd
Posting Genius (adatapost)
Moderator
8,648 posts since Oct 2008
Reputation Points: 2,136
Solved Threads: 1,241
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You