I have managed to create a linked table between two access databases using standard DAO techniques.

I have a minor problem, I want to link a table from one database to another database that has a table of the same name. In which case i want to rename this link table to something else.

Does anyone know how to have the option of naming a linked table, so i don't get any naming conflictions.

Any Ideas!

Mark