Access can't link more than one Sybase table, but Excel can ???

[Guest]

Hi,

I'm trying to link tables in a Sybase DB to an Access DB. I have defined
successfully the Sybase DB as an ODBC source, and I can connect to it with
Excel. In Excel, I can import the tables content without any single problem.

However, when I try to link tables from the same Sybase DB in Access, I
ALWAYS get an error: "Reserved error (-7748): there is no message for this
error" after having selected a table from the (correct) list of tables from
the Sybase DB which Access shows me, EXCEPT if:
- there are no tables defined in Access
- I link one table only from the Sybase DB to Access !

Anybody had the same problem ? Any idea how to solve it ?

Thanks for your help.

Balex

 

[Mary Chipman [MSFT]]

I assume you're using the Linked Table Manager with a DSN? If so, try
writing DAO code with an ODBC connection string (instead of a DSN).
That gives you more control, and you won't have so many hidden layers
to debug.

--Mary