Using Microsoft Access with SQL Direct

Microsoft Access (version 2002 onwards) has the ability to create "Linked Tables". These are tables of data that are held outside of Access in an external database or file. Linked tables can be based, for example, on data in SQL Server. With SQL Direct, you can base linked tables on data that is actually in PDMS rather than a native SQL database. Access will not know the difference.

Two methods of defining linked tables are presented. The first method requires that an ODBC resource has first been created. The second method defines linked tables directly using OLE DB.

For further details about linked tables, see your Microsoft Access documentation.