Re: How do I created a query in Access that points to SQL Server 2000?
- From: MGFoster <me@xxxxxxxxxxx>
- Date: Wed, 28 Jun 2006 18:44:07 GMT
woody wrote:
I have an access program, and I want to migrate the queries to SQL
Server 2000. I've already migrated the database and data over. I'm
not quite sure how to add a query in the Access form to point to SQL
Server. Any help is appreciated.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Are you using an .adp or .mdb Access file type?
If an .mdb file type you can use SQL Pass Through (SPT) queries. Open a
new Query object in design view. Select Query > SQL Specific > Pass
Through. The view will change to the SQL view. Type in the SQL command
that does whatever you want. In the query's "ODBC Connect Str" property
(View > Properties) enter the ODBC connect string: either a DSN or a DSN
less connect string (see http://www.connectionstrings.com/).
If an .adp, just create a new view or stored procedure under the Queries
tab of the database window.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRKLOAYechKqOuFEgEQIK8ACfedgTLdPbHMXUh+Af8hIDb5F0dQ0AoJ6Z
UZy+53NUdRJBDIkFb7OdR18y
=iR3h
-----END PGP SIGNATURE-----
.
- References:
- Prev by Date: Re: Totals Query Help
- Next by Date: Data type mismatch in criteria expression.
- Previous by thread: How do I created a query in Access that points to SQL Server 2000?
- Next by thread: Re: Excel rows to Access columns?
- Index(es):
Relevant Pages
|
