Linked Tables

[A real begineer]

I thought it would be a good idea to set my data tables as linked tables, and access them through another Acess Database containing the forms and queries. In this way I would have a shell / data set up.

Does anyone understand how these links are set up and controlled by access. If I move the tables data to another file or folder they are lost. I would like to have some control over where the data is placed, so I guess ultimately I want to be able to tell the system on set up that the data tables reside in file xxx on C drive or g drive or whatever.

 

[kal-el]

A common method is to check the links when the front-end is started and if they are broken prompt the user to enter the path & file name of the back-end. You can re-link them via code by looping through the Front-End's TableDefs collection and using the TableDef.Connect property.