Does anyone know of a good reference for EXPLAINING the various Type and Option parameters to the OpenRecordset call? I have found truckloads of documentation that states uber-helpful things like "dbReadOnly opens the recordset as read-only". Wow - who would have guessed?
I'm trying to figure out the impact of, for instance:
1. what is the difference between Type:=dbOpenForwardOnly and Option:=dbForwardOnly;
2. what is the difference between Type:=dbOpenDynamic and Type:=dbOpenDynaset;
3. what is the consequence of using Type:=dbOpenDynaset and Option:=dbReadOnly at the same time.
Most documentation and explanations only repeat what MS puts in BOL and similar sites, a few explain some minor helpful things like dbOpenTable cannot be used with linked tables, but I have not found anything that really goes into detail about what can and cannot be done, in what combinations.
There are 5 types and 12 options - and since they are not all mutually exclusive, that means theoretically (2 ^ 5) * (2 ^ 12) possible combinations to try, then exhaustively test all possible properties and methods in the combinations that don't crash on opening, in both ADO and DAO. That's a bit more work than I'm willing to tackle.