Connection settings / Share Deny None etc

[munkee]

Hi all,


I am messing around once again with my data access pages.
I found a list ages ago when I was doing something different regarding what each of the DB connection locks actually mean.

For example:

Share Deny None = blah blah
Read Write = blah blah

But I have misplaced the link (deleted in a fit of rage more likely). Does anyone happen to know where I could find such a list? I cant seem to grab anything correct when just typing in the connection settings in google I just get lots of "help me" kind of forum posts listed.

Thanks,

Chris

[NeoPa]

I normally just use Context-Sensitive Help. For this I'd type OpenConnection then press F1.

Context-Sensitive Help
In Office programs generally, there is a very easy way to get help on a particular item, be it a procedure, an object, or even an object property. Simply put the cursor on the word you want help for (or select the word) then press F1. This brings up the help page relevant to the word or selected text.

[munkee]

Doh! I had actually been using this the other day as well but never even gave it a second thought here. Thanks

[NeoPa]

I expect you'll benefit from treating it as a friend. It's where I get most of my answers from.

[munkee]

Value Definition
DB_MODE_READ
Lets you open a read-only copy of the database.

DB_MODE_WRITE
Lets you open a write-only copy of the database.

DB_MODE_READWRI TE
Permits multiple processes to open and modify the database.

DB_MODE_SHARE_D ENY_READ
Prevents others from opening in read mode.

DB_MODE_SHARE_D ENY_WRITE
Prevents others from opening in write mode.

DB_MODE_SHARE_E XCLUSIVE
Prevents others from opening in read/write mode (DB_MODE_SHARE_ DENY_READ | DB_MODE_SHARE_D ENY_WRITE).

DB_MODE_SHARE_D ENY_NONE
Neither read nor write access can be denied to others.