Linked Tables from multiple databases of SYBASE.
Posted on 2003-10-22
I am using MS Access 97 with SYBASE ASE 11.9.2 with odbc driver 4.1.00.28(latest ebf 10719 from sybase).
My question is I have got multiple databases in SYBASE Server say x, y,z.
I am able to link tables from an access mdb to database x with a particular username and password, like this I link several tables in access with database x, now upto here it's fine,
now I link tables in database y with different user name and password.
Access is able to link the tables, but when I try to open the tables in database y from access it says
[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]dbo.tablename not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output)
same things happens if If I do the other way round, in the sense first connect to Y and then X, I am unable to open the tables in X.
so I can't have tables from multiple databases in same Access mdb ??
Is this the limitation of MS Access.
Please help me.