R
Robin Guest
I have a database collection (comprising front end, back
end and launch databases) which is used by 3 different
users groups, all having different back-end databases (in
terms of data, not structure) and on 3 different
platforms; a Windows 2000 server, a peer-to-peer setup and
a standalone pc.
In summary, the same database structure is used by our UK
office in a network, our UK reps (with the back end
restricted to contact in their area only) and with a
completely different data set by our US office on a peer-
to-peer. I want if at all possible to use the same front
end for all 3 groups.
This means that the front end has a variable path to the
back end on between the different platforms. (The launch
database simply checks that the front end is no older than
the central master version and updates it if it is)
So, I need to be able to change the SourceTableName* in
code as the front-end starts and correct the path to
linked access tables based on the path from the client to
the server.
*If this is where the link path is stored.
I have tried various methods and all seem to collapse
because I cannot change the properties of a tabledef in a
collection.
Does anyone know an easy way to change the linked table
path without having to redefine all of the tables on the
front end database?
I hope that I have clearly explained the problem and thank
you for reading this far!
end and launch databases) which is used by 3 different
users groups, all having different back-end databases (in
terms of data, not structure) and on 3 different
platforms; a Windows 2000 server, a peer-to-peer setup and
a standalone pc.
In summary, the same database structure is used by our UK
office in a network, our UK reps (with the back end
restricted to contact in their area only) and with a
completely different data set by our US office on a peer-
to-peer. I want if at all possible to use the same front
end for all 3 groups.
This means that the front end has a variable path to the
back end on between the different platforms. (The launch
database simply checks that the front end is no older than
the central master version and updates it if it is)
So, I need to be able to change the SourceTableName* in
code as the front-end starts and correct the path to
linked access tables based on the path from the client to
the server.
*If this is where the link path is stored.
I have tried various methods and all seem to collapse
because I cannot change the properties of a tabledef in a
collection.
Does anyone know an easy way to change the linked table
path without having to redefine all of the tables on the
front end database?
I hope that I have clearly explained the problem and thank
you for reading this far!