Contents Index Microsoft Excel (Microsoft 3.51.171300) Microsoft FoxPro (Microsoft 3.51.171300)

ASA SQL User's Guide
  Server Classes for Remote Data Access
    ODBC-based server classes
      Server class odbc

Microsoft Access (Microsoft 3.51.171300)

Access databases are stored in a .mdb file. Using the ODBC manager, create an ODBC data source and map it to one of these files. A new .mdb file can be created through the ODBC manager. This database file becomes the default if you don't specify a different default when you create a table through Adaptive Server Anywhere.

Assuming an ODBC data source named access.

CREATE TABLE tab1 (a int, b char(10))
AT 'access...tab1'

or

CREATE TABLE tab1 (a int, b char(10))
AT 'access;d:\pcdb\data.mdb;;tab1'

or

CREATE EXISTING TABLE tab1
AT 'access;d:\pcdb\data.mdb;;tab1'

Access does not support the owner name qualification; leave it empty.


Contents Index Microsoft Excel (Microsoft 3.51.171300) Microsoft FoxPro (Microsoft 3.51.171300)