K
Ken Smith
I am the administrator of a frontend backend application uisng Access 2003
that is installed in 45 locations. In most cases, the application is run from
the server rather than having the app on the end user desktop. Each
deployment of an upgrade, however, means linking the front to the back end.
I would like to move to a scenario where the application is on individual
PCs that are then linked to the back end automatically by the end users each
time they launch their application. I already have a table of offices with a
field detailing the path to the data file and envision the application
opening to a Startup Screen which asks the end user to identify his office
before he proceeds. The Command button to proceed would trigger the function
that does the relinking, reading the path from a field completed on the form
when the office is selected.
I will greatly appreciate help from a more exalted Access guru with the code
as my VBA is terribly weak and my managerial duties don’t allow me the time
or practice to really grasp and maintain sufficient knowledge to use that
great tool.
that is installed in 45 locations. In most cases, the application is run from
the server rather than having the app on the end user desktop. Each
deployment of an upgrade, however, means linking the front to the back end.
I would like to move to a scenario where the application is on individual
PCs that are then linked to the back end automatically by the end users each
time they launch their application. I already have a table of offices with a
field detailing the path to the data file and envision the application
opening to a Startup Screen which asks the end user to identify his office
before he proceeds. The Command button to proceed would trigger the function
that does the relinking, reading the path from a field completed on the form
when the office is selected.
I will greatly appreciate help from a more exalted Access guru with the code
as my VBA is terribly weak and my managerial duties don’t allow me the time
or practice to really grasp and maintain sufficient knowledge to use that
great tool.