J
June Macleod
Hi there
I have a database which runs all the time. It has a form with a timer on it
(TimerForm) which constantly checks for requests for reports.
I have a second database, CompactDatabase, which compacts the backend data
(in a third database) once a day.
My problem is that when the CompactDatabase routine is running my TimerForm
encounters an error as it cannot access the backend data.
To solve this I would like to shut down my TimerForm for the period when the
CompactDatabase is running and then start it up again.
My question is how can I reference the TimerForm in one database from the
second database and get it first to close and then later, once the
compactdatabase routine has completed, to reopen.
I would be gratefully for any help.
Thanks
June
I have a database which runs all the time. It has a form with a timer on it
(TimerForm) which constantly checks for requests for reports.
I have a second database, CompactDatabase, which compacts the backend data
(in a third database) once a day.
My problem is that when the CompactDatabase routine is running my TimerForm
encounters an error as it cannot access the backend data.
To solve this I would like to shut down my TimerForm for the period when the
CompactDatabase is running and then start it up again.
My question is how can I reference the TimerForm in one database from the
second database and get it first to close and then later, once the
compactdatabase routine has completed, to reopen.
I would be gratefully for any help.
Thanks
June