Forum Discussion
How to write to an access database from mosel
I have created an access database and I am trying to connect to and then write to that database. I am working currently in the Workbench. My code is as follows:
DBcxn := "mmodbc.odbc:LoadMax.accdb"
SQLconnect(DBcxn)
where DBcxn is a string. I get the following error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQLSTATE=IM002
[Microsoft][ODBC Driver Manager] Invalid connection string attribute, SQLSTATE=01S00
Does this indicate an issue with ODBC driver setup, or something else?
1 Reply
For working with Access databases you need an ODBC database driver for Access.
This error message indicates that no suitable driver is installed (NB: the driver needs to match bitness of Xpress, so you require the 64bit version).
