The number of connections to the database can be counted by retrieving the
database user/connection information from the MDB and LDB files. For the
sample code for this task in Access 2002 and 2003, please see this Web page
(it has a link to the Access 2000 version, too):
To visually see the information, Microsoft's LDB Viewer can be used to view
the current users of any Access database on the network. You may find a
link to this tool and other free diagnostic tools in the "Free Microsoft
Access Troubleshooting Tools" section on this Web page:
for all your database needs.
for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)