找不到可安装的ISAM

Question

我需要帮助。在vb.net中编译我的系统后遇到错误

以下是我的代码

Dim dtStudentPermit As DataTable
Dim dtExcelData As DataTable
Public constring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Exam.accdb;Jet System.OleDb.Database Password = graduation"
Public connect As New OleDbConnection

Private Sub Identification_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    connect.ConnectionString = constring

    If connect.State = ConnectionState.Closed Then
        connect.Open() <------< 'Error: Could not find installable ISAM.
        MsgBox("Connection is Open")
    Else
        MsgBox("Connection is Closed")

    End If
End Sub

Answer 1

这应该是：

 ... ";Jet OLEDB:Database Password = graduation"

请参阅http://www.connectionstrings.com/ace-oledb-12-0/with-database-password/

在大多数情况下，如果你得到‘找不到可安装的ISAM'，你可以怀疑你的连接字符串。

使用DAO访问通常比使用ADO快得多。