|
Home > Archive > MS Access Multiuser > April 2005 > Determining if an MDB has been opened twice, or if a given code pr
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Determining if an MDB has been opened twice, or if a given code pr
|
|
| Brad Ashforth 2005-04-22, 3:24 am |
| Is there a way to Determine if an MDB has been opened twice, or if a given
code process is currently running? I have a client who makes multiple copies
of the .mdb and occasionally opens more than one, and each has full copies of
code and linked tables, and there is a process that should NOT be run
concurrently.
I've suggested storing a flag in one of the linked tables, but that is not
the client's preferred approach .. they would prefer something like VBs
"App.PreviousInstance", but not on the whole .mdb, just on the code (sub)
that's running. I don't think this is possible, but thought I'd check first.
--
Thank you,
Brad Ashforth
| |
| Van T. Dinh 2005-04-22, 3:24 am |
| In that case, you should try implementing the code from The Access Web
article:
http://www.mvps.org/access/api/api0041.htm
--
HTH
Van T. Dinh
MVP (Access)
"Brad Ashforth" <banospam@nospam.nospam> wrote in message
news:008D107C-5D37-4046-9418- EA7E7FCBED6F@microso
ft.com...
> Is there a way to Determine if an MDB has been opened twice, or if a given
> code process is currently running? I have a client who makes multiple
copies
> of the .mdb and occasionally opens more than one, and each has full copies
of
> code and linked tables, and there is a process that should NOT be run
> concurrently.
>
> I've suggested storing a flag in one of the linked tables, but that is not
> the client's preferred approach .. they would prefer something like VBs
> "App.PreviousInstance", but not on the whole .mdb, just on the code (sub)
> that's running. I don't think this is possible, but thought I'd check
first.
>
> --
> Thank you,
>
> Brad Ashforth
|
|
|
|
|