Re: Execute queries in back-end database via ADO !?!

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 13:47:40 -0500

"David" <eliasmerkin@tittersnatch.com> wrote in message
news:CFFD8E19-E122-4B74-8714-FD881D59A940@microsoft.com...
> I found that by defining an ADO connection to my back end database, I can
execute a SQL query stored in my back end database. Has anyone used this
technique and is it any more or less efficient than storing the queries in
the local database?
>
> I figured If i put all my tables and queries in the back end, I can do
away with my table links and use the ADO connection to connect and
disconnect thus not maintaining any connection to my back end except when I
need it.

As long as your data is stored in an MDB file all query processing is
local. What program would you expect to execute the query on the back end?
In a remote back end scenario the remote computer is simply acting as a
remote hard drive. It does NONE of the processing.

Your solution is actually less efficient because now the query definition
has to be pulled over the wire as well as the data to execute it. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Re: Newbie question about formula based values
    ... if the query hangs or if Access crashes or is someone restarts ... If you want to execute the code from your web site, you can do that as well. ... If your web site can execute SQL code against an Access database, ... In Windows scheduler, create a new scheduled task based on Microsoft ...
    (comp.databases.ms-access)
  • TIP #308: Twylites concerns
    ... If, as you say, the simple change of adding a place for [$db execute] ... likely the result of a query against a system catalog. ... > especially for a pure-Tcl implementation for a specific database. ... 'execute' functionality that you discussed above address this concern? ...
    (comp.lang.tcl)
  • Re: .Execute vs. .RunSQL - Speed vs. Size
    ... >to know which is faster - Dim a database and then use the db.execute method ... Execute a sequence of action queries. ... Note that Execute requires you to resolve any query ... can gain orders of magnitude better improvement by making ...
    (microsoft.public.access.formscoding)
  • Re: disable index while doing insert into
    ... source and target table have multiple indexes, ... to execute this query but when i've deleted the indexes on target ... This is a price you have to pay on any database not just Sybase. ...
    (comp.databases.sybase)
  • Execute queries in back-end database via ADO !?!
    ... I found that by defining an ADO connection to my back end database, I can execute a SQL query stored in my back end database. ... I figured If i put all my tables and queries in the back end, I can do away with my table links and use the ADO connection to connect and disconnect thus not maintaining any connection to my back end except when I need it. ...
    (microsoft.public.access.queries)