closing another database

[Guest]

Hello.
I'm the administrator of two access 2003 db's. One db (db1) updates data
that the other db (db2) uses. The problem is that if a user has db2 opened, i
have an error in the updating process.
How can I, from db1, force db2 to close before the update process begins?

Thanks,

Luis

 

[Guest]

See this link:

http://support.microsoft.com/kb/304408/en-us

Basically, it involves using a flag file of some sort. DB1 places the file
when it needs to close db2. Set up a timer in db2 that checks for the
existence of the flag file. If the flag file exists, then db2 closes.