Link to BE at installation?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken Eisman - 31 Aug 2005 18:26 GMT

I need to deploy a split database at a different site, so the location of
the BE will be different than it is here in my development environment. Is
there any way to set the location of the BE during installaion?

I'm using MS Access 2003 and Visual Studio Tools for Office.

Thanks
Ken

Reply to this Message

Paul Overway - 31 Aug 2005 21:12 GMT

You'd have to run some post install process wherein you'd pass the install
location and then relink the tables via script. Or while installing the BE,
install a reg key that specifies the location and then relink in the FE
based on that reg key.

Signature

Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

>I need to deploy a split database at a different site, so the location of
>the BE will be different than it is here in my development environment. Is
[quoted text clipped - 4 lines]
> Thanks
> Ken

Reply to this Message

Ken Eisman - 31 Aug 2005 23:07 GMT

Is there some code that could run automatically whenever the database starts
up that senses whether or not the tables are linked and then allow me to
browse to the BE if they are not?

Thanks
Ken

> You'd have to run some post install process wherein you'd pass the install
> location and then relink the tables via script. Or while installing the
[quoted text clipped - 9 lines]
>> Thanks
>> Ken

Reply to this Message

Douglas J. Steele - 01 Sep 2005 00:45 GMT

Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web" for one approach.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Is there some code that could run automatically whenever the database
> starts up that senses whether or not the tables are linked and then allow
[quoted text clipped - 16 lines]
>>> Thanks
>>> Ken

Reply to this Message