Solved

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

Posted on 2004-04-08
4
1,113 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 75 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 75 total points
ID: 10790722
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Web page design problem 3 41
Disable the weekends on datepicker control 6 51
Whice version VisualStudio for new Dev Laptop? 10 41
search by any word in column 5 29
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 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