Unable to set AutoCommit to false in MS Access

[Abhinav Anand]

Hi guys,
I use MS Access as the backend database and JdbcOdbcDriver driver as the jdbc driver. I want to support concurrent connections so to disable concurrent updates to my tables I try to set the connection's auto commit mode to false. But when I try to execute this code:
con.setAutoCommit(false);
It does not works. The message i get states that the auto commit mode cannot be set at this paticular position.
Any suggetions ??
Thanks

[Asanka Nanayakkara]

Hi.
I assume that you are using JDBC DBC Bridge to connect to Access database. You can’t do transaction handling using Access; Access a database doesn’t have built in transaction log or it doesn’t support transaction handling as his big brother SQL Server. (Remember they are completely different type of databases).
Regards
Asanka