Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / November 2004

Tip: Looking for answers? Try searching our database.

Re-linking tables could not find installable ISAM

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karl Irvin - 08 Nov 2004 20:55 GMT
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
Bruno Campanini - 08 Nov 2004 22:21 GMT
> NewConnection = "DATABASE=" & ThisPath & "\" &
> "DataTransferUtility4.mdb;TABLE=tPreferences"

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

Bruno
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.