Linking tables

[Rob.Mills]

Just wanted to get thoughts and the preferred way to link a table.

Linking all tables permanently or linking them through queries using the IN clause?

 

[iancampbellian]

linking tables

if you're changing the back end data lots of times you'll probably want to code it with vba and link it with a command button on a form.

It also allows users to link easily to different backends if you wish to give them permissions to do so.

to summarise, the code should bring up the windows dialog box (like windows explorer file open), you select the file to link to and then it repoints your linked tables to it.

 

[kupe]

Hi Ian
I'm posting a similar query today. But your answer would be handy with an input box. I wonder if you knew the VB code you referred to? Grateful for it, is possible. In my new struggles with learning code I have yet to reach such dizzy heights. Cheers