Show User Roster in Split Database

[webunit]

I'd like to show a roster of users in a multiuser database. I used to use
the ShowUserRosterMultipleUsers code which I found in a knowledge base
article. This worked fine for the unsplit database which resided on a
network server. Now, however, I've split the database and so only the
back-end is on the server.

The OpenSchema line in the following code no longer works:
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i, j As Long

Set cn = CurrentProject.Connection

' The user roster is exposed as a provider-specific schema rowset
' in the Jet 4.0 OLE DB provider. You have to use a GUID to
' reference the schema, as provider-specific schemas are not
' listed in ADO's type library for schema rowsets

Set rs = cn.OpenSchema(adSchemaProviderSpecific, _
, "{947bb102-5d43-11d1-bdbf-00c04fb92675}")

I get Runtime Error 3251 "Object or provider is not capable of performing
requested operation." I suspect that this is because the code is in the
front-end on my computer and not on a server. (Please correct me if I'm
wrong.)

Does anyone know how to get around this problem? How do I get a user list
in a split database?

Thanks.

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted this same
question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, you should see an
"Advanced Options" link at the bottom of the page. You can type the names of
the various groups into the Newsgroup box, separating each newsgroup name
with a semicolon.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups.

 

[webunit]

Already answered in another newsgroup to which you posted this same
question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, you should see an
"Advanced Options" link at the bottom of the page. You can type the names of
the various groups into the Newsgroup box, separating each newsgroup name
with a semicolon.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups.

Another excellent post. Sorry I wasn't aware of the multiple posting
method. I did correct the code and it's working now. Thanks again.