如果你尝试在Windows7或其他64位操作系统下打开access 数据库，可能你会碰到如下的错误： System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
为解决这个问题，你只需要打开Visual stadio, 进入菜单My Project -> compile -> advanced compiler options，设置一下 the target cpu to x86. 当然如果你用的是中文版，请选择相应菜单。由于当前没有64位的Jet.OLEDB.provider，所以这里只能通过设置CPU选项，强制 .NET framework使用32位的数据库引擎.
数据库联接事例如下：
Dim ds As New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As OleDbConnection Dim strConn As String Dim da As OleDbDataAdapter strConn = "Provider = Microsoft.Jet.OLEDB.4.0;" strConn &= "Data Source = c:/Northwind.mdb;" conn = New OleDbConnection(strConn) ds = New DataSet da = New OleDbDataAdapter("Select * from Products", conn) Try da.Fill(ds, "Products") Catch ex As Exception MessageBox.Show(ex.ToString) End Try DataGridView1.DataSource = ds.Tables("Products") End Sub
