Re: Error using JET_SCHEMA_USERROSTER

From: M Smith (msmith_at_avma.org)
Date: 10/08/04 

Date: Fri, 8 Oct 2004 09:17:56 -0500

So are you saying that the Microsoft Jet 4.0 OLE DB Provider might not be
installed on the production machine? If not, how do I distribute the
Microsoft Jet 4.0 OLE DB Provider. If I remember correctly, it's no longer
included in anything above MDAC 2.1.

"Val Mazur" <group51a@hotmail.com> wrote in message
news:%23rtEH8NrEHA.3428@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Based on error message I would say that version of provider, which you
have,
> does not support this functionality and does not return any information
for
> the specified SchemaID. Another potential issue is the SchemaID is
different
> for this version of provider. The issue here is the
adSchemaProviderSpecific
> is not a required option, which each OLEDB provider suppose to support and
> it is not a reliable way.
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "M Smith" <msmith@avma.org> wrote in message
> news:%23iIKaiHrEHA.536@TK2MSFTNGP11.phx.gbl...
> >I want to count the number of users who are currently connected to a
> > specific Access 2000 database. I'm using the code below in a form
inside
> > the database. It works on my development machine but it does not work
> > when
> > I try to implement it at a different location.
> >
> > Dim intUsers As Integer
> > Dim rst As ADODB.Recordset
> > Const JET_SCHEMA_USERROSTER = "{947bb102-5d43-11d1-bdbf-00c04fb92675}"
> >
> > Set rst = CurrentProject.Connection.OpenSchema(
adSchemaProviderSpecific,
> > ,
> > JET_SCHEMA_USERROSTER)
> >
> > Do Until rst.EOF
> > intUsers = intUsers + 1
> > rst.MoveNext
> > Loop
> > rst.close
> > Set rst = Nothing
> >
> > When I try to run it in production at a different location I get an
error
> > that says: "3251 Object or Provider is not capable of performing
requested
> > operation". My development machine is Win 2000 and production is XP SP2
> > with Access 2000 already loaded on it. Does anyone have any insight on
> > this.
> >
> > Thanks
> >
> >
>
>

Relevant Pages

  • Re: Word 2003 - SP1 - Serienbriefe
    ... Da scheint es an der OLE ... "Microsoft Jet 4.0 OLE DB Provider" Muss hier was ... Oder sollte der Provider neu installiert werden? ... >> Serienbriefleiste bei einem bestehenden Serienbrief nicht ...
    (microsoft.public.de.word)
  • RE: about msdtc
    ... Error 7399 When You Run a Linked Server Query That Uses the OLE DB ... Provider for Microsoft Jet ...
    (microsoft.public.sqlserver.dts)
  • Re: rs.RecordCount issue...
    ... OLE DB Provider for Microsoft Jet) or "MSDASQL (the OLE DB Provider for ODBC ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: MS Access driver
    ... How about Microsoft Jet 4.0 OLE DB Provider? ... There have been some changes in Access forms stored in the .mdb file but Ole db ...
    (borland.public.delphi.database.ado)
  • Re: OleDbPermission failed
    ... Microsoft Jet 4.0 OLE DB Provider ... I couldn't find a separate download ... You probably need to install jet provider. ... Miha Markic [MVP C#, ...
    (microsoft.public.dotnet.framework.adonet)