Question how to link one front end with many back ends (1 Viewer)

N

nileflower

New member

Local time

Yesterday, 16:31

Joined

Feb 18, 2009

Messages

5

• Mar 8, 2013

• #1

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

Wino Moderator

Staff member

Local time

Yesterday, 16:31

Joined

Aug 30, 2003

Messages

36,124

• Mar 8, 2013

• #2

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

Ad astra

Local time

Today, 00:31

Joined

Sep 27, 2004

Messages

1,521

• Mar 9, 2013

• #3

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.