Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007

The problem is with the ODBC connection - in general. If you are going
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. ADO
requires using VBA. If you want to use the Access Query Tool you will
have to create a temp table in the Access mdb into which you would write
an ADO datapull from the server, and then you can query that. The
alternative is to write the queries directly in the ADO command object
and execute it. You will write the results of the ADO query into a temp
table in the Access mdb the same as above.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Listing all the tables in MS access Databsae using ODBC
    ... query do it for an ODBC connection,or is that limite to ADO and has ...
    (microsoft.public.dotnet.framework.adonet)
  • 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: cant get query to run over ADO, but works fine in Access inte
    ... Thanks for the suggestions, Richard. ... the query so that unchanging parts of it are stored as a query with the part ... As I've had trouble with synchronizing ADO ... > Execute method of the ADO Connection object, but the issue is the same - you ...
    (microsoft.public.data.ado)