Question how to link one front end with many back ends

[nileflower]

i have one front end access database and want to connect with more than one back end at time
but both back ends have same table names

 

[pbaldy]

When you link the tables, you can give them different names. In other words, the actual table name might be "TableName", but the linked table name could be "TableNameDB1" or whatever.

 

[Lightwave]

Be warned linking is very easy - in most circumstances though the front end forms and queries will stop working as they will not pick up any new names you call tables duplicate tables.