Limit the number of instant loaded Access database on a SINGLE machine

A

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top