I have a (linked) table called 'Deliveries' linked to a table of that
name in the back-end.

I now want to create a new link to another table named 'Deliveries' in
a different back-end.

I would like to call the linked table in the front-end
'DeliveriesPrevious' but, of course linked to the back-end table named
'Deliveries'

I can create a table and connect it:
Dim aTable As DAO.TableDef
Set aTable =
CurrentDb.CreateTableDef("DeliveriesPrevious")
aTable.Connect = ";DATABASE=" & backEndDataFile
but this will assume that the back-end contains a table
'DeliveriesPrevious'.

Is it possible to specify the specific table in the back-end?

Jim

Don't worry about this. I have done it !!!

Jim