Updating a front-end and back-end database to the local machine automatically

[Ihar]

Hi

I have a database split onto a front end and a backend.

The front end sits on the users local machine and the backend on the server. Additionally, there is a local copy of the backend on the local machine for use when the person is out of the office and is only used for reference purposes, not for update purposes. The user is able on login to select which backend database they want to use and the links to the tables get automatically refreshed

What I am trying to do is to run a piece of code, on request, to update the local copies of the front-end and backend that are stored locally with those that are stored on the server.

I have no idea how to do this, however, I do have the location of the shared databases and local database path stored in an .ini file, so they are easy enough to retrieve, I suspect that I wont be able to update the local frontend database as it is open, so I suspect I have to open a new database and do the copying from there.

Any assistance would be appreciated

Steve

 

[Bob Hairgrove]

Hi

I have a database split onto a front end and a backend.

The front end sits on the users local machine and the
backend on the server. Additionally, there is a local
copy of the backend on the local machine for use when
the person is out of the office and is only used for
reference purposes, not for update purposes. The user
is able on login to select which backend database they
want to use and the links to the tables get
automatically refreshed

What I am trying to do is to run a piece of code, on request,
to update the local copies of the front-end and backend that
are stored locally with those that are stored on the server.

I have no idea how to do this, however, I do have the location
of the shared databases and local database path stored in an
.ini file, so they are easy enough to retrieve, I suspect that
I wont be able to update the local frontend database as it is
open, so I suspect I have to open a new database and do the
copying from there.

Any assistance would be appreciated

Steve

I would use a simple DOS .bat file or Windows scripting to accomplish
this. Since you are merely copying and deleting files, you wouldn't
have to worry about the application running when it is being
replaced. You could copy the .bat file to the Windows Startup folder
and it would run when the user logs on. Delete the .bat file from an
Access VBA procedure when the application runs. Making backup copies
of the MDB files from the .bat program would be a good idea, too.

 

[Guest]

Hi,

Sorry to ask this mid-thread as I cant help with your problem, but would
like to ask if you could with mine as I see you have a setup I am trying to
achieve.

You say here "
The front end sits on the users local machine and the backend on the server.
Additionally, there is a local copy of the backend on the local machine for
use when the person is out of the office and is only used for reference
purposes"

Could you possibly tell me how you get them to choose which copy they use
when starting the Database.

Thank you!

 

[Ihar]

David, sorry for the slow reply

I have a login form in the database, and on there the person chooses which
database they want to use, there is then a refresh button which will go and
refresh the links for all the tables in the database to the related mdb
file, if you like I can forward this form, table and related modules to you.
Unfortunately I don't have a web site I can place this on for download
purposes.

Steve