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.

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

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"Jim Burke in Novi" <Jim Burke in (E-Mail Removed)> wrote in
message news:472DC532-05AC-4E6E-8EEF-(E-Mail Removed)...
> 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.

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 news:472DC532-05AC-4E6E-8EEF-(E-Mail Removed),
Jim Burke in Novi typed:
> 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.