MS Access Connection
It is used for connection to the Microsoft Access database.
Connection Parameters
The following parameters are set during the connection setup:
- Caption contains the connection name set by a user.
- File name: the path to the DB file containing the required data is specified. Parameters can be manually entered, or it is possible to press
button to call Open file window. - Username is not used for connection to Microsoft Access.
- Password: the password set by the DB user is specified.
- Test: test of the specified connection settings.
- Show system tables: when selecting this checkbox in the import wizard that uses this connection, the system DB tables available to a user become visible.
- Quote names: if the database objects names (for example, names of tables, fields) contain spaces or reserved characters, it is required to use framing characters fixing the name start and end.
- Configure quotes represents the information field that enables to define which framing characters are used for connection to this DB. Square brackets are used for Microsoft Access.
- Do not use DBMS client: this parameter is not available for Microsoft Access.
- Comment: it is possible to provide any reference connection data in this form.
Note: To provide connection to the database, it is required to install Microsoft Office or Microsoft Access Database Engine with the same bitness as the Megaladata application/server bitness.
Compatibility
Versions 95, 97, 2000, 2003, 2007, 2010, 2013 and 2016.
See also: