🚀 go-pugleaf

What is exact error message (or better error code)? Are Access db secured -
if so, may be user has not enough rights to view overall schema. Are Jet SP
installed on both computers and are MDAC versions the same?

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server and MS Jet (MS Access) databases.

"Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> ???????/???????? ?
???????? ?????????:
news:gunaalqrneguyvaxarg.h56nr50.pminews@207.105.83.65...
> My app uses an OpenSchema() call to get a list of field names when a
database
> is opened, to verify that the ones required for correct operation exist.
The
> database is an Access 2000 .mdb file.
>
> The syntax of the call was this:
>
> dataConn->OpenSchema(siColumns, EmptyParam, EmptyParam, FieldNames);
>
> 'FieldNames' is a TADODataSet object.
>
> The call works consistently on this machine, and on another machine at the
> office.
>
> It does not work on any other machines at the office, or on another
machine
> here.  An exception is thrown with the "blah blah blah not supported by
> provider" message.
>
> Both machines here use Windows 2000, as do most (if not all) machines at
the
> office.
>
> Well, after a large amount of searching, I tried setting the restrictions
> parameter, like this:
>
> Variant tvars[3];
>
> tvars[0]=Unassigned();
> tvars[1]=Unassigned();
> tvars[2]=cstring; // name of table
>
> dataConn->OpenSchema(siColumns, VarArrayOf(tvars, 2), EmptyParam,
> FieldNames);
>
> And it works on both machines here now.  I haven't tried it on the other
> office machines yet.
>
> So, why does this call work with an empty second parameter on one machine
but
> not another?
>
>
> --
>  - Mike
>
> Remove 'spambegone.net' and reverse to send e-mail.
>
>