Can you dynamically link Access tables?

[Guest]

Is there a way for me to dynamically link tables when my Access application
first starts up so that I don't need to have the application DB created with
the links to a specific path and file name? I'd like to be able to look at
the path name the application is running in (using CurrentDb.Path) and then
link to the data DB that is stored in that path.

 

[Alex Dybenko]

Hi,
here a sample code:
http://www.mvps.org/access/tables/tbl0009.htm

 

[Nick Coe \(UK\)]

Yup, been a while since I did that myself though..

Take a look at this code. You _will_ need to modify it but
it ought to get you started.

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

and this

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

and this

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

Good luck

--
Nick Coe (UK)
Available - Will work for money
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In Jim Burke in Novi typed: