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

[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

 

[Adrian Jansen]

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