Accessing Access DB readonly

[eddparsons]

Hi,

I have a Database Connection setup in Ebase looking at an MS Access database. I'm only using it for read access and I want other users using Access to be able to update it. Currently if Ebase has read from the DB and then another user then opens it in Access, it will open in read only mode and they are unable to update. I have tried using connection strings that specify ReadOnly and DenyNone but that doesn't seem to have made any difference.

Is it possible to accomplish this?

My Database Connection is set to use Database type MS Access and Connection type of Pooled Connection with the following settings:

factory: com.ebase.jndi.DataSourceFactory
driverClassName: com.inzoom.jdbcado.Driver
url: jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\forestnet2\fnet_f\Databases\Councillors\cllr_data - test.mdb;IzmJdbcEsc=yes;IzmRoyaltyFree=643223965;OpenMode=DenyNone

The DB will be migrated to SQL Server eventually but there a lot of different systems that use this DB so this will be a bit of a project.

Regards,
Edd Parsons

[Jon]

I've never come across this. I'm wondering if it's something to do with the reuse of the connection, so maybe possible things to try:

• o Use a direct non-pooled connection - this guarantees that each user request will use a new connection
  o Use a pooled connection but set the minimum number of connections to 0 - in the hope that each new user will always establish a new connection

[eddparsons]

Direct non-pooled connection seems to have done the job.

Thanks very much Jon

Regards,
Edd