[AccessD] data types

It is specifically because you are using ADO provider, so its both (or
neither) the connection and/or recordset.  The ADO constant 202 is
equivalent to Access text, and SQL NVarChar.  If you want "dbText" you
have to open it with DAO.  
There's a chart of the ADO Enums at
http://able-consulting.com/adodatatypeenum1.htm.

Hth
Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Sunday, January 25, 2004 12:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] data types


It's the constant for a Text field. It's a real pia keeping up with all
the constants -- I wish they'd offer just one set -- just one set...

Susan H.


> It could be an Ntext field
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan 
> Harkins
> Sent: Saturday, January 24, 2004 3:24 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] data types
>
>
> I'm getting a adVarWChar (202) data type on an Access Text field -- is

> the
W
> because it's coming via a Recordset or the Connection object? From the
docs
> I've read so far, it isn't really clear.
>
> Susan H.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com