ADO teething problems


I'm trying to make the crossover to ADO and I've stumbled into a
strange quirk in A2K (mdb, no linked tables).

I have a function which generates an INSERT query on the fly and runs
it.
DAO: CurrentDB.Execute StrSQL - works fine
DoCmd.RunSql StrSQL - works

But with ADO using cn.execute, I get Error -2147217833
"The field is too small to accept the amount of data you attempted to
add. Try inserting or pasting less data."

....which leads me to think that ADO treats field size/ type conflicts
differently to DAO / Straight Jet SQL queries.

Any takers?

.

Relevant Pages

  • Re: Run timer Error
    ... If I work with ADO in mdb, do you know if there is a way equivalent a DAO, I ... Dim DB As DAO.Database, strSQL As String ... primary key avoids duplication records. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADO VS. DAO
    ... DAO is superior to ADO when using Jet data. ... It's not a matter of whether it's an ADP or an MDB, ...
    (comp.databases.ms-access)
  • =?Windows-1252?Q?Re:_Laufzeitfehler_13_beim_=D6ffnen_eines_Recordsets?=
    ... dass bestimmte Arten von Zugriffen auf eine *.mdb u.U. ... mit DAO deutlich schneller laufen als mit ADO. ... vollen Geschwindigkeit des jeweiligen Rechners zu ver- und bearbeiten. ...
    (microsoft.public.de.vb.datenbank)
  • Re: Recordset ? defaults mdb->DAO, adp->ADO
    ... > Why does the form recordset seem to default to DAO in an MDB and ADO ... Because in an MDB, Access uses DAO to manage the data, while in an ADP ...
    (microsoft.public.access.forms)
  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)