Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007
- From: lyle fairfield <lyle.fairfield@xxxxxxxxx>
- Date: Fri, 30 May 2008 18:00:23 -0700 (PDT)
I don't use ODBC connections by personal preference. But there is NO
problem with ODBC connections "in general". The cleverness of the ODBC
connection technology is quite amazing. The notion of using a temp
table in an MDB to interact with an SQL-Server table and populating
and maintaining that table through code is bizarre and naive.
The OP could, I suppose, correct his query; an alternative would be
just to use an ADP. There is little wrong with ADPs that is not also
wrong with ODBC connected MDBs.
On May 30, 3:38 pm, Rich P <rpng...@xxxxxxx> 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 Developersdexhttp://www.developersdex.com***
.
- References:
- Prev by Date: Re: Loads of errors when querying MS SQL Server Express 2005 from Access 2007
- Next by Date: Access and Palm PDA
- 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
|
