K
kev100 via AccessMonster.com
I've got an Access 2002 app with 2 linked tables.
1 is an ODBC link to a VFP table (Visual Fox Pro)
The Second is a non-odbc link to a DBIII table.
I need to add another link to a second ODBC VFP table.....however...when I do
this, THAT link will error out.
The first odbc link will remain okay....but the additional one simply won't
work.
Curiously.....If I delete both ODBC links. Close and re-open the app and
create a link the the second ODBC link (which would not work before).....it
will work fine then. If I attempt to add the other ODBC (the one which was
previously first)....then IT will not work.
This is what makes me suspect that there is some issue with Access having
multiple ODBC links in 1 app (and it seems like I remember reading something
about it somewhere).
IS this the case...and, if so, is there any work-around / solution?
Thanks,
KEV100
1 is an ODBC link to a VFP table (Visual Fox Pro)
The Second is a non-odbc link to a DBIII table.
I need to add another link to a second ODBC VFP table.....however...when I do
this, THAT link will error out.
The first odbc link will remain okay....but the additional one simply won't
work.
Curiously.....If I delete both ODBC links. Close and re-open the app and
create a link the the second ODBC link (which would not work before).....it
will work fine then. If I attempt to add the other ODBC (the one which was
previously first)....then IT will not work.
This is what makes me suspect that there is some issue with Access having
multiple ODBC links in 1 app (and it seems like I remember reading something
about it somewhere).
IS this the case...and, if so, is there any work-around / solution?
Thanks,
KEV100