Re: Listing all the tables in MS access Databsae using ODBC

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

From: Steve Hurst (steve.hurst_at_instem-lss.co.uk)
Date: 05/13/04 

Date: Thu, 13 May 2004 02:07:41 -0700

I came across a similar article. But I am baffled how microsoft using MS
query do it for an ODBC connection ,or is that limite to ADO and has
gone with ADO.NET

They present you with a list of tables.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007
    ... The problem is with the ODBC connection - in general. ... to be using Access as a front end for a Sql Server backend - you will ... have more consistent/better results using ADO instead of ODBC. ... an ADO datapull from the server, and then you can query that. ...
    (comp.databases.ms-access)
  • RE: ODBC query in VB code Need HELP
    ... Everything for ADO is in the first 2 messages that I gave you. ... Since your pass-through query already exists (including the ... Dim STRSQL As String ...
    (microsoft.public.access.formscoding)
  • Re: Connecting to Query
    ... practice examples of the ADO Command, Parameters, etc. you explained below. ... Second, with the selected territory ... >> combo box to select a product from a query based primarily on a link ...
    (microsoft.public.access.formscoding)
  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: Passing parameter to a select query
    ... Try returning a a simple Select query ... ' need to wait while the first query refreshes ... it works fine for external linking of the database within Access. ... you have an ODBC connection for your database? ...
    (microsoft.public.excel.programming)