Access 2000. Can I reference an object in one database from another?

  • Thread starter Thread starter June Macleod
  • Start date Start date
J

June Macleod

Hi there

(I tried this in another forum a few days ago but got no response. Hoping
someone here can help)


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
 
You will have to set some sort of flag in one database, which you can read
from the other one, to decide whether you are compacting or not. Maybe a
table linked to both databases, with a yes/no field you can set from the
compact routine, and read from the timer routine.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top