Could Not Find Installable ISAM? 1

[MajP]

Here is my code for establishing an ADODB connection from a word document

Public connMain As ADODB.Connection
Public Function EstablishConnection(strDBName As String)
'*****************************************************
' Purpose:   Open ADO Connection
'
' Assumptions: Called from Sub Main
'
' Effects: N/A
'
' Inputs:   strDBName - String containing the file path
'                       to the database
'
' Returns: N/A
'*****************************************************
   On Error GoTo errlbl
   Set connMain = New ADODB.Connection
   With connMain
      .CommandTimeout = 15
      .ConnectionTimeout = 15
      .CursorLocation = adUseClient
      .Provider = "Microsoft.ACE.OLEDB.12.0"
      .Open strDBName
   End With
   Exit Function
errlbl:
   MsgBox Err.Number & ": " & Err.Description
End Function

When I use this code here

rsPrograms.Open strSql, connMain, adOpenForwardOnly, adLockOptimistic

I get the error
"Could not find installable ISAM"

I believe the code is fine, because it works on 9 out of 10 computers running the same word document. The computers are all windows XP and office 2007.

Here is a pretty painful thread on the subject

http://social.msdn.microsoft.com/fo.../thread/62ee4978-ca29-48d3-9367-6dd4ab639d2d/

But this confused my more than answer anything.
This talks about registry settings, but does not address ACE

http://support.microsoft.com/kb/209805

Anyone have any experience with this?

Also it used to work on my computer, but no longer.

 

[lameid]

Took a minute to look at the links you have and searched...

I found a thread that *may* be more useful...

http://social.msdn.microsoft.com/Forums/en-SG/vbgeneral/thread/1a85fd1f-3ccc-40a2-934c-fff2fa7d71d2

Good luck and happy hunting.

 

[MajP]

Your the man! That worked a charm. I searched and searched and did not find that. Worked like a charm.