The API does not allow the DNCL tables to be opened read-only

[GoogleCodeExporter]

- Currently the API ALWAYS opens the DNCL tables with read/write permission.
- In some situations only read-only access is required for the DNCL tables.
- This unnecessary use of read/write access can cause locking problems when the 
DNCL tables and/or GDB are held in a shared network environment.

Suggested changes;
- The various methods which open the DNCL tables should provide the user with 
the option to request that the tables are opened read-only
- Wherever possible they should be open read-only (eg in the symbology tools).
- The user should be able to query whether or not currently open DNCL tables 
are read-only or read/write.

Original issue reported on code.google.com by andrewphilipsmith on 14 Jul 2010 at 3:08

• Blocking: #7

[GoogleCodeExporter]

Original comment by andrewphilipsmith on 14 Jul 2010 at 4:07

• Changed title: The API does not allow the DNCL tables to be opened read-only

[GoogleCodeExporter]

try adding mode=adModeShareDenyNone into the connection strings.
Optionally allow mode=adModeShareDenyNone+adModeRead in the connection strings.

- Need to test whether both the jet and ESRI ADO providers support these 
options.
- Ref: http://msdn.microsoft.com/en-us/library/aa140022.aspx

Original comment by andrewphilipsmith on 27 Sep 2010 at 5:53

[GoogleCodeExporter]

The connection strings have been altered to include:
mode=adModeShareDenyNone+adModeRead

This is only a partial solution, as the readonly mode applies only within the 
ADO provide at application level. This does reduce some of the locking problem 
when multiple users are trying to use the DB.

It still requires readwrite assess at the operating system level, in order to 
write a lock file when using an Access DB, therefore this is still a problem if 
the DNCLT are store in Access in a location where the user only has read-only 
privelages.

Reduced from priority high to medium.

Original comment by andrewphilipsmith on 22 Nov 2010 at 2:10

• Added labels: Priority-Medium
• Removed labels: Priority-High

[GoogleCodeExporter]

Original comment by andrewphilipsmith on 4 Mar 2013 at 3:29

• Changed state: WontFix
• Now blocking: #7