how can i write ansi sql quires equalent to ms access and sql ser.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

presend i am using ms access in my programs. but i want my program to support
sql server. if user selects sql server. so, i need to write ANSI SQL, Which
supports both databases and others if required in feature.
so, i at presend i need to know how can i chage my ms access quiries to ansi
sql, so that when user have sql server. my programes should
support/compatable with the other database.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Link the SQL Server tables (or any other ODBC compliant RDBMS tables) to
the Access front-end. Then run Access queries against the linked
tables.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQcFDsoechKqOuFEgEQJCdgCZAaMYWFzwtF2eWk3fmHw2a9xzUWAAoMk9
A/6UkAime5r/s30sWOvlR58o
=4i+3
-----END PGP SIGNATURE-----
 
Back
Top