Could Not Find Installable ISAM

[bconner]

I have an Access 2003 Front End that I am going to email out to 50 people and I want them to be able to push a button that will set the connection to the linked tables on the Back End. Below is the code I have but everytime I execute it I get "Could Not Find Installable ISAM"

Dim tbl As TableDef
 'Refresh the ODBC links to Access Backend tables.
    On Error GoTo err_RefreshTableLinks
    CurrentDb.QueryTimeout = 60
    Screen.MousePointer = 10
    For Each tbl In CurrentDb.TableDefs
        
        'Ignore local tables.
        If tbl.Connect <> "" Then
            'Debug.Print tbl.Name, SearchText(tbl.Connect & ";", "Database=", ";")
           tbl.Connect = "Provider=Microsoft.Jet.OLEDB.4.0; DataBase=\\addfile00\Groups\Billing\Accomplishments\DERM CUSTOMER SERVICE_be.mdb; UserID=Admin; Password=;"
            tbl.RefreshLink
        End If
    Next
    RefreshTableLinks = True
    Screen.MousePointer = 0
    MsgBox "Tables Refreshed Successfully"
    
err_RefreshTableLinks:
    RefreshTableLinks = False
    Screen.MousePointer = 0
    MsgBox Err.Description

 

[boblarson]

So you don't have direct access to the backend table to link it yourself before sending the frontend out?

 

[bconner]

Hey Bob,
I do have access but everyone else out in the field has that server mapped to a different Drive Letter so I figured the easiest way was to just have them set the connection on their end. Maybe I am going about this all wrong is there an easier way?

 

[boblarson]

According to this:

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

(even though it is about Excel)

it will come up with this error if the connection string is incorrect.

Which version of Access are you trying to connect to? (sorry, I didn't remember you said 2003).

Check http://www.connectionstrings.com to find out the connection string for Access.

 

[bconner]

Okay, thanks Bob, that is a good start I'll check out the website.