Linking tables to other databases using code

[JamesBBB]

Hi All,

I am wondering if it is possible to link tables to a database when the database is running and the user has been presented with a welcome screen.

Basically I would have a back end database for each of the collections I have, each of these databases are quite large and contain just one table called Master, all the backend databases have exactly the same fields.

I would then have a client side database which does all the front end work, which contains all the forms, queries, modules, reports etc.

When the user loads the front end Database he will then select the appropriate collection via a button or combo box and then what I would like the code to do is, unlink any linked table that is present (if any) and link to the one he has opted for.

I would imagine I would need to specify the database location on the hard drive and the specify the “master” table to link to.

My question is, simply, is this possible and if it is, could you explain to me how to do it, as I wouldn’t know where to start

Many thanks in advance

James

 

[easyit]

Hi,

You could start with searching this forum with the keyword "relink".

EasyIT