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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
