Hi,

Would anyone have implemented integrating with MSAccess ? I’m having trouble doing an insert operation into MSAccess97 using ODBC Adapter.

Appreciate your reply.

Hello … We have implemented integrations with MSAcces97. We also had some issues with the insert command using the ODBC adapter.

The problem that we ran into was that we had been using one of the ODBC reserved keywords in our insert statement.

Checkout the Microsoft site for a list or send me your email address and I can forward a copy to you.

Kev

Thank you for that.

Hello,

We need to integrate to an MS Access database - I know the Driver name is sun.jdbc.odbc.JdbcOdbcDriver and I see websites that tell me what the connection URL should be (for e.g., jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\path\to\your\database.mdb) - but, I do not see where I can enter this information on the JDBC adapter page… could somebody on this thread kindly paste a sample JDBC Adapter Connection entry to connect to an MS Access database? This would be greatly appreciated!

Best Regards,
Vijai