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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David (eliasmerkin_at_tittersnatch.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 09:06:02 -0700

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.

Relevant Pages

  • Re: Execute queries in back-end database via ADO !?!
    ... > I found that by defining an ADO connection to my back end database, ... execute a SQL query stored in my back end database. ... As long as your data is stored in an MDB file all query processing is ... What program would you expect to execute the query on the back end? ...
    (microsoft.public.access.queries)
  • Re: What is access databases login name?
    ... It is not the database password in Access, but rather you have to be a ... of a workgroup: this involves creating a workgroup security file in access, ... > i set the password within access, and input the password to ADO connection ... > also the ADO connection string needs login name, so i wonder if the login ...
    (borland.public.delphi.database.ado)
  • Re: replacing Outlook forms
    ... You can also run programs by using Windows Scripting or ... ADO Connection and execute code on the database. ... "Pete" wrote in message ...
    (microsoft.public.outlook.program_addins)
  • Re: Which API will be appropriated for retireve the schema info of RDB
    ... You could use OpenSchema method of ADO connection. ... relies on a OLEDB providers capabilities to return information about ... in some cases you will not get full schema information if provider ... > information of RDBMS database, such as SQL Server or Oracle etc. ...
    (microsoft.public.data.ado)
  • Reading with ADO from Access database over network
    ... same workgroup. ... when trying to open the ADO connection ... database is open exclusively... ...
    (microsoft.public.excel.programming)