Linking tables in Access 2002 through ODBC

[Mike]

I am receiving an error

Reserved error (-7748); there is no message for this
error. (Error 3000)

while trying to link a Sybase 12.5 table...is this an
error with the sybase ODBC dll or the Jet engine?

 

[Charles Fivaz]

I am receiving an error

Reserved error (-7748); there is no message for this
error. (Error 3000)

while trying to link a Sybase 12.5 table...is this an
error with the sybase ODBC dll or the Jet engine?

This solution given to me by Sybase worked for me:

Apparently this error is an Access issue. However, to workaround this
you will need to go into the registry and add a new string value to
the ODBC DSN.

Bring up regedit.
HKEY_LOCAL_MACHINE
+ Software
+ ODBC
+ODBC.ini

Select the Data Source that you are using.
Right mouse click and select New, String Value
(the name is case sensitive) Call it

WorkArounds2

Then select the WorkArounds2 and select Modify.
give this a Value of 40960.

Than will create the String Value of WorkArounds2=40960

Then attempt the link to the table.

Charles Fivaz