?
Solved

Error --> could not find installable ISAM --> TRANSFERDATABASE (ODBC)

Posted on 2004-04-08
4
Medium Priority
?
1,117 Views
Last Modified: 2011-10-03
I am trying to programmatically link SQL SERVER table to a MS ACCESS Database.
Here is my code -->

Function linktable()
        Dim oAccess As Access.Application
        oAccess = New Access.ApplicationClass

       ' Open a database:
        oAccess.OpenCurrentDatabase(filepath:="C:\Documents and Settings\abdullah\Desktop\dbtest.mdb", Exclusive:=False)

        Dim constr
        constr = "ODBC, Description=qqq; Driver = SQL Server; Server=Abdullah; APP = Microsoft Office XP; WSID = ABDULLAH; DATABASE=VSKSUS; TRUSTED_CONNECTION = YES"

        oAccess.DoCmd.TransferDatabase _
        (Access.AcDataTransferType.acLink, _
         "ODBC Database", _
          constr,_
          Access.AcObjectType.acTable, _
          "CustomerInfo", _
          "CustomerInfo", _
          True, True)

End Function

--> I get the error on the DoCmd link sayin "could not find installable ISAM"
I have already checked the Microsoft Support page on the matter --> http://support.microsoft.com/?id=209805

But all the registry keys seem to be fine
Does anybody have a solution or a way around this?

0
Comment
Question by:b_o_b
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 28

Accepted Solution

by:
iboutchkine earned 300 total points
ID: 10790717

The DLL for an installable ISAM file could not be found. This file is required for linking external tables
(other than ODBC or Microsoft Jet database tables). The locations for all ISAM drivers are maintained in the
Windows Registry. These entries are created automatically when you install your application. If you change
the location of these drivers, you need to correct your application Setup program to reflect this change and
make the correct entries in the Registry.

Possible causes:

An entry in the Registry is not valid. For example, this error occurs if you're using a Paradox external
database and the Paradox entry points to a nonexistent directory or driver. Exit the application, correct the
Windows Registry, and try the operation again.


One of the entries in the Registry points to a network drive and that network is not connected. Make sure
the network is available, and then try the operation again.

--------------------------------------------------------
Another cause
The error occures when you are using a different version ACCESS than the original code did so the
"connect" property of the data-control is set wrong. Just set it ot the correct one


also check
http://support.microsoft.com/support/kb/articles/Q155/6/66.asp
0
 
LVL 96

Assisted Solution

by:Bob Learned
Bob Learned earned 300 total points
ID: 10790722
0

Featured Post

Automating Terraform w Jenkins & AWS CodeCommit

How to configure Jenkins and CodeCommit to allow users to easily create and destroy infrastructure using Terraform code.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question