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 SQL Anywhere.
Assuming an ODBC data source named access, you can use any of the following statements to access data:
CREATE TABLE tab1 (a int, b char(10)) AT 'access...tab1'
CREATE TABLE tab1 (a int, b char(10)) AT 'access;d:\pcdb\data.mdb;;tab1'
CREATE EXISTING TABLE tab1 AT 'access;d:\pcdb\data.mdb;;tab1'
Access does not support the owner name qualification; leave it empty.