Linking databases

[throwerm72]

I currently have and Access DB that has imported/linked tables from a MySQL databse running on a server (using and ODBC connection). I need to link the another Access DB with the same tables to my existing Access DB (pulling from a MySQL server).

Essentially i am linking an existing Acces DB to and an Existing MySQL DB using another access db to join the two. Essetialy a user would be able to make change in the exsiting Access db which would change the MySql DB and visa versa. I know this may sound reduntant, and you may be wondering why not just link to the MySql db, but this is how my boss wants it done.

thanks for any help.

[Delerna]

Are you asking how to link to the linked tables in another access database?
If so then I don't think you can. I don't think microft thought that there is any logical reason for doing so, because as you say you can just link to the original tables.

why link to links of links of links of links.......... etc ???

[throwerm72]

Thank You, that is pretty much what I figured also. Glad I'm not going crazy with all the thoughts of this redundant linking.

The issue is my boss had an Acces DB with a pretty extensive set of forms which he still wants to function. This database was recreated in a MySQL databse and a few new tables were added so it server a web page. I tried to tell him I could migrate the existing data, and then we would have to do some reconstruction using the new linked tables (swapping names in forms, or renaming tables, and rebuilding the relationships). He didn't like that idea so he came up with the current scenario, which I originally mentioned.

Thanks for the help and if anybody has any idea to make swaping out an old table with a new linked table when existing relationships or forms are involved please let me know.