VB 2008 : Could not find installable ISAM.
Pls dear, kindly help with this challenge. it has taken the very soul out of me.
I'm trying to query access 2007 database to retrieve some record, but giving this error: Could not find installable ISAM.. While other querries to the same table will work in another/ other forms, it won't just work here.
below is the code:
[B]
Public Class paymentClass
Dim conn As OleDb.OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0 ; Data Souce=|DATADIRECTORY|\ADELABUDB.accdb")
Dim sqlstring As String
Dim dtAdapter As OleDbDataAdapter
Dim dt As New DataTable
Function Retrieve_Companies() As DataTable
sqlstring = "SELECT CompName FROM REGISTRATION"
dtAdapter = New OleDb.OleDbDataAdapter(sqlstring, conn)
dtAdapter.Fill(dt)
dtAdapter.Dispose()
Return dt
End Function
End Class
|