Reading SQL files with Access

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

We recently purchased a electronic timeclock and
software. The software is SQL based and doesn't have a
report writer. The vendor says the SQL file can be read
using Access but they don't support it. We have Access
but cannot figure out how to read the SQL file. Can
someone help me out.
Rgds Ian
 
First, you should tell us which version of Access you have.

Second, with Access 2000, 2002 or 2003, you can link tables from Access
directly to SQL Server by using ODBC. Theses tables will looks like Access
tables but with their storages located on the SQL Server (Access will add a
small arrow beside their icons). This is the easiest way.

Third, you can also use Access Data Project (ADP) instead of linked tables:
excerpt for the forms and modules, the whole database, including queries,
will be stored on SQL-Server. This is the more powerfull way.

This is a very succinct description and there are other possibilities. You
should buy a good book on Access and SQL-Server as a Client/Server solution.

S. L.
 
Back
Top