Limit the number of instant of an MSAccess database

[Access97User]

I'd like to implement a routine (or function) that will
check to see whether this very current database
(containing the desired routine/function) has been loaded
previously or not. I would like to limit the number (only
1 instant) of opening instant of a security Access97
database on a single machine (user can open the same
database concurrently on different computer(s), however).

I've tried to log user's and user's machine name into a
record in a table, each time user logs into our database,
but this scheme does not work well, since there are users
who are accessing our database via Citrix Metaframe
Terminal; these users will have the same machine name (the
citrix server machine), and these users are the ones have
the needs to open the same database from different Citrix
Terminals at the same time.

Thanks in advance for any input or response,

 

[Dirk Goldgar]

I'd like to implement a routine (or function) that will
check to see whether this very current database
(containing the desired routine/function) has been loaded
previously or not. I would like to limit the number (only
1 instant) of opening instant of a security Access97
database on a single machine (user can open the same
database concurrently on different computer(s), however).

I've tried to log user's and user's machine name into a
record in a table, each time user logs into our database,
but this scheme does not work well, since there are users
who are accessing our database via Citrix Metaframe
Terminal; these users will have the same machine name (the
citrix server machine), and these users are the ones have
the needs to open the same database from different Citrix
Terminals at the same time.

Thanks in advance for any input or response,

Have a look at this link and see if it does what you want:

http://www.mvps.org/access/api/api0041.htm
API: Preventing multiple instances of a database

 

[Jeff Conrad]

Hi,

Are you talking about seeing if a workstation is trying to open more than one instance of the same
database?

If so, try this link. It *may* be what you are after:

http://www.mvps.org/access/api/api0041.htm