OBDC Difference between Database Mode=Read and Share Deny None

[Stormin']

Hi all,

When connecting to an external data source, in this case an Access database, you can set the access permissions to a few values:

• Read (Lets you open a read-only copy of the database)
• ReadWrite (Permits multiple processes to open and modify the database)
• Share Deny None (Neither read nor write access can be denied to others)
• Share Deny Read (Prevents others from opening in read mode)
• Share Deny Write (Prevents others from opening in write mode)
• Share Exclusive (Prevents others from opening in read or write mode)
• Write (Lets you open a write-only copy of the database)

I'm wondering what the difference is between Read and Share Deny None. My intention is to use Excel purely as a viewer for data in a database, but the descriptions overlap.

Does anyone know? Thanks

[Stormin']

I still haven't found an answer to this, does anyone know?