How to Connect from VB.Net to Access 2007?

Dim Cnn As New OleDb.OleDbConnection(“Provider=Microsoft.ACE.OLEDB.12.0; “ & _
“Data Source=C:\data.accdb; Persist Security Info=False;”)

Cnn.Open()

‘…………………..Retrieve data, or manipulate data here using DataAdapter, Command, etc.

Cnn.Close()

Before using the above code, please download and install AccessDatabaseEngine first.
Here is the link you can download:
http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

One Response to “How to Connect from VB.Net to Access 2007?”

  1. kong kevnophea Says:

    តើformគេធ្វើការគណនាបានរីទេ?បើបានចូលរកឧទាហណ៌?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: