Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Server classes for remote data access » ODBC-based server classes

 

Server class msaccessodbc

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.

 Data type conversions: Microsoft Access