Hi there everyone,
I'm using MySQL 3.22.27 on a Linux machine as the server, and MSAccess97
as the front-end via MyODBC 2.50.29.00. I'm using one system DSN.
I'm setting up an MSAccess97 database to act sa the front-end for some of
my databases on MySQL. My particular project is for a database of jobs. I
need to be able to link this with a table from my other database, which is
a database of accounts/contacts. My userID has identical permissions for
both databases, which reside on the same MySQL server.
If I open the link to my jobs database first, attempts to open the
accounts/contacts database during the session will render an "ODBC
call--failed". If I open the link to the accounts/contacts database first,
then attempts during the same session to open the table(s) from the jobs
database will fail with the same error.
Further details of the error:
- I get a second prompt which reads: "[TCX][MyODBC]Table
'contactmgr.test_oc' doesn't exist(#1146)". It looks like it's trying to
access the table I want from the first database which I opened, which in
this case is wrong.
How do you think can I solve this? Please help. Thanks!!! :-)
-+[ Jijo Sevilla ]+-