Number of connections to Access database

[OJFEnterprises]

Hello,

Does anyone know of a way to determine the number of database
connections currently in existence for a particular .MDB? Say...I
point a file path of an .MDB to some component, funky module, etc., and
it returns the number of connections currently talking to an MDB.
Thanks for any suggestions in this odd request!

 

['69 Camaro]

Hi.

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):

http://support.microsoft.com/default.aspx?id=285822

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:

http://www.Access.QBuilt.com/html/links.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)