Running a timer on the backend database

  • Thread starter Thread starter Paul Fenton
  • Start date Start date
P

Paul Fenton

I have a split database, back end datafile, 8-10 front end copies
running at any given time. The owner wants certain data run off to a
separate database that he'll upload to his web server for client
queries. He wants to upload every hour.

I have the query that generates the upload db and I have a form with a
timer that triggers creating that upload db every hour. That form
however, is open in every front end copy. So, obviously, each copy
will be triggering at different times running that query several times
an hour.

That may or may not be a problem and I'll have to test it in the
working environment, but I'm wondering...

Is there a way to open that timing form in the back end data file and
have it run from there??


Paul Fenton
(e-mail address removed)
 
Paul said:
I have a split database, back end datafile, 8-10 front end copies
running at any given time. The owner wants certain data run off to a
separate database that he'll upload to his web server for client
queries. He wants to upload every hour.

I have the query that generates the upload db and I have a form with a
timer that triggers creating that upload db every hour. That form
however, is open in every front end copy. So, obviously, each copy
will be triggering at different times running that query several times
an hour.

That may or may not be a problem and I'll have to test it in the
working environment, but I'm wondering...

Is there a way to open that timing form in the back end data file and
have it run from there??
Click to expand...

I wouldn't mess with the BE db. Why not create a separate,
special purpose FE mdb that links to the same BE db as the
regular FEs?
 
Back
Top