Front end Backend linking

[SteveE]

I quite often take backup copies of my FE and BE databases home to work on the FE. Because the BE resides on our server and the FE’s on individual PC’s. I need to re-link the tables.
My question is can I automate this facility either by macro or code so I can run an update link i.e. when taking home,
link the copied FE to the copied BE (\mytables_be.mbd) and when returning my development FE to the server (\\myserver\db\mytables_be.mbd)

Any advise welcome.

 

[Parker]

I believe the Northwind db has an example of how to link in code or take a look here

 

[SteveE]

Many thanks for the lead, and yes it appears works fine for links to a single backend. But my FE links to two different BE's what I would like to do is to be able to

link my FE to \my1_be.mbd
link my FE to \my2_be.mbd
once the backend has been copied to my PC
and again to return the links to normal once the new modified FE is replaced back into use

link my FE to \\myserver\my1_be.mbd
link my FE to \\myserver\my2_be.mbd

I had hoped to be able to run a macro to do this but cannor see how.

thanks for the advise.

 

[Parker]

There are various solutions to your problem but in basic terms: Create a table to hold all the possible links to your BE in both locations then use a routine fired by a command button.

But an easier solution may be to just import the tablesinto your front end when you take it home and split it again on your return.

Or copy the BE onto your Lapie (or whatever) and tell linked table manager to prompt for a location on start up.

Do a search on linked table manager and table def. Also take a look at this It is not what you want but it will give you the necessary info to set up your links using a table and routine.

HTH