Function ShowUserRosterMultipleUsers()
'Source: kb 198755.
Dim cn As New ADODB.Connection
'Dim cn2 As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i, j As Long

cn.Provider = "Microsoft.Jet.OLEDB.4.0" <<<- what would
this be for .accdb ?
cn.Open "Data Source=C:\Data\Northwind2003.mdb"

The above is from Allen Browne's (much appreciated) website. Problemo
is that this is Ok on Access2k or .MDB databases but what does the
cn.provider need to change to for .accdb databases, Ac2007 & AC2010?

(I use this in Ac2000 to count users as it's the only reliable way. I
did have a user table to check for users login and logout. Which was
fine when users closed the FE correctly. Only problem is that some
users, well quite a few actually) don't. So when they open up later
they are still flagged as being linked in. This function gives me
control of the number of users, which is what I want.)

"elg" <envirocomp (AT) ukonline (DOT) co.uk> skrev
Look here :
http://www.utteraccess.com/forum/Con...-t1946959.html

Bjarne