Sharing Tables With Two (2) Different Databases (1 Viewer)
- Thread starter lhooker
- Start date
isladogs
MVP / VIP
- Local time
- Today, 00:55
- Joined
- Jan 14, 2017
- Messages
- 18,209
Yes it is possible. In fact it is perfectly normal to do so in split databases where tables in a common backend database are linked to each copy of the frontend database.
However, you need to realise the tables will be 'live' in each database so any changes made in one database will be picked up in the other database
However, you need to realise the tables will be 'live' in each database so any changes made in one database will be picked up in the other database
isladogs
MVP / VIP
- Local time
- Today, 00:55
- Joined
- Jan 14, 2017
- Messages
- 18,209
Billions of examples!
Just link to the tables you want from each of your databases
To create linked tables go to External Data ... Import ... Access.
Select Link to the data source then browse to the external database and select the table(s) you want
NOTE: you can also IMPORT the tables but this will create new separate copies of each table which you don't want
Just link to the tables you want from each of your databases
To create linked tables go to External Data ... Import ... Access.
Select Link to the data source then browse to the external database and select the table(s) you want
NOTE: you can also IMPORT the tables but this will create new separate copies of each table which you don't want
- Local time
- Yesterday, 18:55
- Joined
- Feb 28, 2001
- Messages
- 27,147
And to be explicit, you seem to be talking abut having two back ends. Yes, you can do that. Click once on your External Data ... Import ... Access ... Link path for each external file. You can create links for tables in back-end A and other links for tables in back-end B.
