Exclusive Open Mode for Databases

[codeman]

Hi,

I wrote an application that is split in aan front end MDE and a
back end MDB for the data. The behaviour i want to establish is that
both the MDE and MDB are opened exclusive. After a user has opened the
MDE no other user can open the MDE at the same time. The MDE uses
attached tables from the MDB. The MDE should open the data MDB
exclusive so no other user can open the MDB while the attached tables
are used by the MDE.

The restrictions are that the solution has to work regardles the
following settings or open methods:
- if a /excl argument is used in the command line or not
- the MS Access option "Default Open mode for Databases" is set to
Exclusive or not
- the user opened the MDE using Open Exclusive or Normal in the Open
dialog

In other words, a user starts the MDE that uses attached tables from
the MDB. After that no other user can open the MDE or MDB while the
first user is stil using the MDE, regardles the local MS Access
settings mentioned above. The MDE should enforce Exlusive open mode on
itself and on the attached MDB.

How can this be done?

Thanx

The Codeman