CODEWITHSUNDEEP
ms-access
bumble_bee_tuna
bumble_bee_tuna

Reputation: 3563

ms-access client server configuration

How can I easily set the path for the front end to connect to the backend database. Do I have to use the linked table manager every time ?

I found a tool here but it isn't very reliable. There is no simple config to set the back end path ?

Upvotes: 0

Views: 243

Answers (1)

Martijn van der Jagt
Martijn van der Jagt

Reputation: 524

When importing a table from another MS-Access database you can choose between a 'table' and a 'linked source'. If you now choose the 'linked source' and then you select the file of the other MS-Access file (where you select the table you want to link to ) you will get the table in your front-end Access as a normal table with one new property 'linked table'.

Now you can do everything on the selected data in both Access environments. The data will be synchronised as soon as you enter one record (make a change in one line and go to the next line). You do not need to visit the linked table manager any more at all.

Upvotes: 1

Related Questions