Re: Need a recordcount in ADO recordset

Bob,
"Select count(*) FROM tablename" would work very nicely if I was just
retreiving data against one table. But the actual queries are more
complicated.
I suppose I should have provided a little background first. I
apologize for not doing so earlier.

There are 10 queries (which have all been optimized for
performance,etc) and the results are what the user wants. Some queries
have as many as 9 tables joined. The longest any of them runs is about
3 minutes via an external Oracle utility "Toad". Today the user runs
these all manually in Toad, exports the data form all of the queries
manually to Excel files, and reformats the Excel files to pass along to
other depts.
They want to do some reporting on some other queries via a simple
Access GUI (for a single user) The user is simply wanting to
centralize these queries with a simple GUI and have a form to launch
and run the queries.
User also requested a run log of these queries showing the start/end
times and the number of rows retrieved for each query.

One question that comes to mind, would DAO be faster and/or more
efficient when Access is going against an Oracle database?
I'm neutral either way on that issue, but would favor whichever you
feel would be the better solution technically.

Thanks.

.

Relevant Pages

  • Re: Need a recordcount in ADO recordset
    ... retreiving data against one table. ... But the actual queries are more ... couldn't you create a View using that complicated query? ... When working against a Jet database, ...
    (microsoft.public.data.ado)
  • Re: Can I pass parameters from a macro to query?
    ... then runs 3 queries to export 3 excel files. ... Each of the queries now requires 2 parameters when they the run. ... I have to enter each of the dates 3 times - once for each query. ... you might be running action queries where it ...
    (comp.databases.ms-access)
  • Re: Can I pass parameters from a macro to query?
    ... then runs 3 queries to export 3 excel files. ... Each of the queries now requires 2 parameters when they the run. ... I have to enter each of the dates 3 times - once for each query. ... you might be running action queries where it ...
    (comp.databases.ms-access)
  • importin excel files from sharepoint
    ... We have Excel files on a Sharepoint site. ... database to filter and make queries. ...
    (microsoft.public.sharepoint.windowsservices)
  • open excel file through access
    ... i have a form in microsoft access with buttons used to open tables and run ... simple queries. ... and excel files. ... Prev by Date: ...
    (microsoft.public.access.forms)