Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Fri, 30 May 2008 17:45:58 -0500
Rich P wrote:
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 ***
I have no significant ODBC problems with any version of Access connecting to
any version of SQL Server.
Would you really create a front end that did all of its database operations
from code?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- References:
- Prev by Date: Re: Simple / Complicated Query?
- Next by Date: Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007
- Previous by thread: Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007
- Next by thread: Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007
- Index(es):
Relevant Pages
|
