[unixODBC-support] cannot write to Access MDB using unixodbc+mdbtools-odbc-drivers

Nick Gorham nick.gorham at easysoft.com
Thu Mar 27 09:45:00 GMT 2008

Ketjes wrote:

> Hi,
> I've got a Microsoft Access-database (database.mdb) with one table 
> (table1) containing one field (field1) of the type "long integer".  
> From within Perl I would like to INSERT a record in this table !
> When I perform the Perl-script (see at the bottom), then I get the 
> error "Error at Line : syntax error near INSERT".  I'm pretty sure the 
> SQL-syntax is okay.  A SELECT-query works without ANY problem.
> I herby include all relevant configuration-files...
> Anyone any advice what might be wrong ?
> Many thanks,
I would guess this will need to be a question for the mdb tools folks.

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list