468,170 Members | 2,046 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,170 developers. It's quick & easy.

Re-linking tables could not find installable ISAM

In the module below, I get a "Could not find installable ISAM" error on the
tdf.refresh link.
The NewConnection refers to a valid database/table.

My References include VBA, Access 9.0 Object Library, DAO 3.6, OLE and VBA
Extensibility 5.

Do I need some other reference or ??
Dim db As DAO.Database, tdf As DAO.TableDef
Dim ThisDB As String, ThisPath As String, NewConnection As String

'Get current folder
ThisDB = CurrentDb.Name
ThisPath = Left(ThisDB, InStrRev(ThisDB, "\") - 1)
Set db = CurrentDb
Set tdf = db.TableDefs("tPreferences")

NewConnection = "DATABASE=" & ThisPath & "\" &
"DataTransferUtility4.mdb;TABLE=tPreferences"

tdf.Connect = NewConnection
tdf.RefreshLink
Nov 13 '05 #1
1 4063
"Karl Irvin" <88********@comcast.net> wrote in message
news:Z2Rjd.382125$D%.229495@attbi_s51...
NewConnection = "DATABASE=" & ThisPath & "\" &
"DataTransferUtility4.mdb;TABLE=tPreferences"


You missed at least one ";"
NewConnection = ";DATABASE=" ....

Bruno
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nel | last post: by
4 posts views Thread by Craig Bailey | last post: by
1 post views Thread by Chris | last post: by
11 posts views Thread by James | last post: by
1 post views Thread by James | last post: by
4 posts views Thread by Alan Walkington | last post: by
1 post views Thread by John Ryan | last post: by
10 posts views Thread by James | last post: by
8 posts views Thread by Beowulf | last post: by
3 posts views Thread by David Hickman | last post: by
1 post views Thread by gcdp | last post: by
reply views Thread by kamranasdasdas | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.