Re: DAO to ADO and stored procs

Hello,


Yes, it's slower for most operations...

But what I don't understand is, why with the same DB engine do we have some errors on some 'complicated' queries (Several tables, including other queries, some calculated field) ?

These queries are all working well in MSAcess itself (of course !!) and also with DAO, but hangs with ADO !!

ADO is reporting several kinds of error (depending on the query). The problem is that I didn't find (for the moment...) why some queries are executed without problems and others not !!!

Thanks

Regards

Frederic


MikeR wrote:
Frédéric SCHENCKEL wrote:
> Does anybody have some tips or experience about this conversion ?
My experience is that with an Access DB, ADO is quite a bit slower.
Mike
.

Relevant Pages

  • Re: Amend SQL Query with VBA
    ... Given the complexity of the queries, if supported by the DB Engine, use a ... stored procedure and pass the dates as parameters. ... Using ADO, it would be pretty straight forward. ...
    (microsoft.public.excel.programming)
  • Re: Slow queries
    ... so the query gets slower ... > am using queries to get these values. ... If I need to write the sale back to the Detail ...
    (microsoft.public.access.queries)
  • Re: Parsing large amounts of data (200,000 entries) with XML?
    ... > I didn't add queries into that list because queries are one of two ... > XML is going to be a bit slower than reading from a linked list ... > processing of the XML tags. ...
    (microsoft.public.vb.general.discussion)
  • Re: Cluster indexing time increasing each week
    ... If I don't recreate ... the fragmentation causes performance of the ... >queries to get slower and slower. ... Are these SELECT queries or INSERT, UPDATE, or DELETE, and whichever, ...
    (microsoft.public.sqlserver.server)
  • SQL Queries SLOW after Oracle 8i to 10g migration
    ... The server is of higher processing power. ... Some SQL Queries run faster and some queries run slower. ...
    (comp.databases.oracle.server)