Exporting to an Access Database

pondering42 · 10-07-2009, 04:26 PM

I'm trying to get an ODBC connection setup for exporting to an access database. I've worked through a good number of issues and verified that it can make an ODBC connection to it but when I try to export to the database beyond the "Export down to the Encouter Details" leve I'm getting the following error message:

Code:

 
[2:00:06 PM] ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement.

I'm in the process of checking to make sure all the tables and fields are setup correctly but the error made me wonder if it was an ACT problem or configuration issue. Any suggestions on what to try or check to verify that?

For reference I'm using the ODBC drivers from the "2007 Office System Driver: Data Connectivity Components" and the following connection string (per the MS download page instructions):

Code:

 
Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=c:\test.mdb;

EQAditu · 10-07-2009, 05:44 PM

I couldn't tell you what the problem is without seeing the same error in ACT's log file. Which you probably need to enable safemode to not get a gigantic SQL block but that's probably the problem to begin with. The Microsoft databases don't seem to support multiple statements in one send, which safemode disables.

pondering42 · 10-07-2009, 06:15 PM

Going into safe mode fixed the issue. Thank you sir.