Linking Backend MDB Tables Programmatically

[Tim M]

Hi,

I have an application that has the data split in tables in a backend mdb
file. These tables are linked in the frontend mdb application file. The
application could be deployed on different company's networks, so the folder
locations of each file may vary.

I want to way to enable users to either type in or browse (from a form) the
location of the backend mdb file, to create or refresh the table links from
the frontend, rather than have to use the normal linked table refresh utility.

Also I want deploy the frontend database as an MDE file so the code is
protected, so users wouldn't be able to refresh the table links manually
anyway.

How can I create and/or refresh the table links programmatically. I know
this is possible since I did it one before several years ago, but can't find
the code I used.

Cheers,
Tim M

 

[Ofer Cohen]

Check this link on "Relink Access tables from code"

http://www.mvps.org/access/tables/tbl0009.htm

It a bit long, but you can find an example for what you need (using the
connect)

 

[Tim M]

Thanks Ofer, this is great.

Check this link on "Relink Access tables from code"

http://www.mvps.org/access/tables/tbl0009.htm

It a bit long, but you can find an example for what you need (using the
connect)