The problem is the path, not getting the user list!
Originally posted by Jerrie
I know a way through ADO recordset...
Dim conn as adodb.connection
Dim rst as ADODB.recordset
Set conn = currentproject.connection
set rec = new adodb.recordset
Set rst = conn.OpenSchema(adSchemaProviderSpecific, , _
Do until rst.eof
This is getting the User Roster feature in Jet 4.0 to get all the users connected to a DB.
I got the user list in using plain ol' SQL:
SELECT MSysAccounts.FGroup, MSysAccounts.Name, MSysAccounts.OLDSID, MSysAccounts.Password, MSysAccounts.SID
FROM MSysAccounts IN 'C:\Utils\Programming\Projects\Access CellSlim\users.mdw'
The problem is I wanna do it flexible, so I could change the location of the .mdw file.