sql server

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

Guest

Is it possible to select/retrieve data within access 2002 from a sql database
(.dba) i think
 
DB2, perhaps? "DBA" is usually an abbreviation for Database Administrator.

You can use use normal Access Select Query if you link the SQL Tables to the
Access MDB. The main processing controller will be JET / Access.

Alternatively, you can use Pass-Through Query to get the SQL server to
process the selection for you and to return only the selected rows to
Access. In this case, you will need to construct the SQL string using the
SQL server syntax (which may be different from JET / Access syntax)

You will need the appropriate ODBC driver for the SQL server.
 
Back
Top