Establishing a Connection
The objects available within our connector are accessible from the "cdata.access" module. To use the module's objects directly:
- Import the module as follows:
import cdata.access as mod
- To establish a connection string, call the connect() method from the connector object using an appropriate connection string, such as:
mod.connect("DataSource=C:\\My.accdb")
Connecting to Microsoft Access
To connect to Microsoft Access, set DataSource to the full path (including filename) of a Microsoft Access database file. For example, C:\Users\Public\Documents\MyDatabase.accdb.