How do I created a query in Access that points to SQL Server 2000?

[woody]

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.

Thanks,

Ray

 

[MGFoster]

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-----

 

[Guest]

Use a pass-through query. You can read that topic in the help file.
When you open a new query in design mode, close the "show table" dialog box
that comes up. Right click on the query and look for "SQL specific"