ASA SQL User's Guide
Server Classes for Remote Data Access
ODBC-based server classes
Server class odbc
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.