D
David
I have a Multi-user system that uses linked tables (yeah,
I know ADO and SQL calls are better, but this system has
40 Meg of code already and we have to support it)
In this system, we need to implement a max user
connections for our "lite version" of the software. Does
anyone know how to check how many users are connected to
a database - the .ldb file contains this information as
Microsoft Access itself uses the lock file to keep tabs
on connections, but I cannot find anyway to access this
information programatically.
A Couple of items that apply:
We are not using workgroup files in this implementation -
all connections to link up tables are done
programatically using the default admin login
As a result all connections are connected using the
default admin user id and password and we simply need to
know how many computers in the network have made the
connection to the central database.
I know ADO and SQL calls are better, but this system has
40 Meg of code already and we have to support it)
In this system, we need to implement a max user
connections for our "lite version" of the software. Does
anyone know how to check how many users are connected to
a database - the .ldb file contains this information as
Microsoft Access itself uses the lock file to keep tabs
on connections, but I cannot find anyway to access this
information programatically.
A Couple of items that apply:
We are not using workgroup files in this implementation -
all connections to link up tables are done
programatically using the default admin login
As a result all connections are connected using the
default admin user id and password and we simply need to
know how many computers in the network have made the
connection to the central database.