check and act on the number of open connections

W

wineguy

Hi,

First post.... patience... is there a way to check the number of open
connections so that the number returned via a function so that it can be
acted upon? I checked MS http://support.microsoft.com/default.aspx?id=285822..
. but not sure how (even if it's possible) to retrieve only the number of
open connections to a form... any help would be greatly appreciated...

Thanks,
 
T

Tom Wickerath

The fact that you are apparently (?) interested in seeing how many users have
a particular form open suggests that you have not split your application into
a FE ("Front-End") and BE ("Back-End") files, and installed separate copies
of the FE onto each user's computer. If this is so, you really should split
the application. More information is available here:

Split the Database
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB
http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top