ADE tools - linked tables post setup issue...

Greetings...

i am using Access Developer Extensions 2003 (Package Wizard) with an
Access 2003 split database (front end +back end). I have created a
distribution bundle but...

What i need to know is how can the front-end determine where the back
end is located when a user decided to perform a custom setup, to a
directory other than the "production" dir...

For example if the linked tables (back end) path is D:\backend how can
this be "refreshed" and replaced with the directory the user has
chosen for the setup (i.e. C:\Program Files\ or C:\Windows or any
other path) after setup has taken place...?

Thank u in advance....

re: ADE tools - linked tables post setup issue...

"Dmitri V" <vrjim45@hotmail.com> wrote in message
news:48c1442a.0411030413.1ba85756@posting.google.c om...[color=blue]
>
> What i need to know is how can the front-end determine
> where the back
> end is located when a user decided to perform a custom
> setup, to a
> directory other than the "production" dir...
>
> For example if the linked tables (back end) path is
> D:\backend how can
> this be "refreshed" and replaced with the directory the
> user has
> chosen for the setup (i.e. C:\Program Files\ or C:\Windows
> or any
> other path) after setup has taken place...?[/color]

You have to make allowance for this in your code.

The best write up I've found is in the Access Developers
Handbook by Getz, Litwin and Gilbert:
Http://www.developershandbook.com

Also look at the info on the Access Web, specifically:
http://www.mvps.org/access/tables/tbl0009.htm


--
Nick Coe (UK)
AccHelp v1.01 Application Help File Builder
http://www.alphacos.co.uk/
Download Free Demo Copy
----