b_o_b
asked on
Error --> could not find installable ISAM --> TRANSFERDATABASE (ODBC)
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.OpenCurrentDatabas e(filepath :="C:\Docu ments 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.TransferData base _
(Access.AcDataTransferType .acLink, _
"ODBC Database", _
constr,_
Access.AcObjectType.acTabl e, _
"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?
Here is my code -->
Function linktable()
Dim oAccess As Access.Application
oAccess = New Access.ApplicationClass
' Open a database:
oAccess.OpenCurrentDatabas
Dim constr
constr = "ODBC, Description=qqq; Driver = SQL Server; Server=Abdullah; APP = Microsoft Office XP; WSID = ABDULLAH; DATABASE=VSKSUS; TRUSTED_CONNECTION = YES"
oAccess.DoCmd.TransferData
(Access.AcDataTransferType
"ODBC Database", _
constr,_
Access.AcObjectType.acTabl
"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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.