Access can't link more than one Sybase table, but Excel can ??? Balex 07.07.2006 12:01:01 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

Re: Access can't link more than one Sybase table, but Excel can ??? "Mary Chipman [MSFT]" <mchip[ at ]online.microsoft.com> 10.07.2006 13:22:41 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 On Fri, 7 Jul 2006 05:01:01 -0700, Balex <Balex[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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