L
lupo666
Hi, a client has asked me the following: I have 3 databases, same
structure, different data, on 3 different remote machines, all of
which use the same external interface MDB. As maintainer, I would like
to use a copy of the interface for all three. So, how can I choose
which database to connect to on the interface start-up?
My solution was, since all databases are mapped to "Z:" depending on
the department where they are deployed, to build a small batch file
which would ask him which database to connect to, unload SUBST and
reload it to the correct path and then start the interface MDB, which
works...
BUT, he wants it done INSIDE the interface! So, the question is: how
can I choose the database to connect to and use its linked tables on
my interface start-up?
Thank you in advance for any help you may provide, Lupo
structure, different data, on 3 different remote machines, all of
which use the same external interface MDB. As maintainer, I would like
to use a copy of the interface for all three. So, how can I choose
which database to connect to on the interface start-up?
My solution was, since all databases are mapped to "Z:" depending on
the department where they are deployed, to build a small batch file
which would ask him which database to connect to, unload SUBST and
reload it to the correct path and then start the interface MDB, which
works...
BUT, he wants it done INSIDE the interface! So, the question is: how
can I choose the database to connect to and use its linked tables on
my interface start-up?
Thank you in advance for any help you may provide, Lupo