how do I link BE new table to FE?
how do I link BE new table to FE?
External Data -> Linked Table Manager
Thanks for the reply. I have tried that though. I have created a new table on the back end which is on the company server. If I go to the linked table manager, the new table does not appear in the list and it just shows the original tables with check boxes at the side of each.
I'm assuming 2010 is similar to 2007.
- Go to the External Data tab
- Choose Access the in Import section
- Browse to the BE DB
- Select the option to Link to the data source
- Choose the new table
- (Possibly enter login info if password protected)
- OK out