in an attempt to follow through on lameid suggestion
I used the following code
Code:
Dim i As Integer
With rst
For i = 0 To (.Properties.Count - 1)
Debug.Print i & " " & .Properties(i).Name & ", " & Properties(i)
Next i
End With
which produced the following results (which honestly I lack the skill to know if it contains any useful information)
Database Type Microsoft SQL Server
0 IAccessor,
1 IChapteredRowset,
2 IColumnsInfo, False
3 IColumnsRowset, False
4 IConnectionPointContainer, 1
5 IConvertType, 0
6 ILockBytes, 0
7 IRowset, True
8 IDBAsynchStatus, True
9 IParentRowset, False
10 IRowsetChange, False
11 IRowsetExactScroll, True
12 IRowsetFind, 0
13 IRowsetIdentity, (none)
14 IRowsetInfo, False
15 IRowsetLocate, 2
16 IRowsetRefresh, 0
17 IRowsetResynch, 31680
18 IRowsetScroll, False
19 IRowsetUpdate, True
20 IRowsetView, True
21 IRowsetIndex, 2
22 ISequentialStream, True
23 IStorage, True
24 IStream,
25 ISupportErrorInfo, False
26 Preserve on Abort, 3
27 Access Order, True
28 Append-Only Rowset, True
29 Blocking Storage Objects, True
30 Use Bookmarks, True
31 Skip Deleted Bookmarks, 3
32 Bookmark Type, False
33 Cache Deferred Columns, 0
34 Fetch Backwards, 0
35 Hold Rows, True
36 Scroll Backwards, 0
37 Change Inserted Rows, 0
38 Column Privileges, True
39 Command Time Out, False
40 Preserve on Commit, 0
41 Defer Column, 24
42 Delay Storage Object Updates, 24
43 Private1, False
44 Filter Operations, 0
45 Find Operations, 0
46 Hidden Columns, True
47 Immobile Rows,
48 Literal Bookmarks, False
49 Literal Row Identity, False
50 Maximum Open Rows,
51 Maximum Pending Rows, False
52 Maximum Rows, True
53 Column Writable, False
54 Memory Usage, False
55 Notification Granularity, True
56 Notification Phases, True
57 Column Set Notification, True
58 Row Delete Notification, True
59 Row First Change Notification,
60 Row Insert Notification,
61 Row Resynchronization Notification,
62 Rowset Release Notification,
63 Rowset Fetch Position Change Notification,
64 Row Undo Change Notification,
65 Row Undo Delete Notification,
66 Row Undo Insert Notification,
67 Row Update Notification,
68 Bookmarks Ordered,
69 Others' Inserts Visible,
70 Others' Changes Visible,
71 Own Inserts Visible,
72 Own Changes Visible,
73 Quick Restart,
74 Reentrant Events,
75 Remove Deleted Rows,
76 Report Multiple Changes,
77 Return Pending Inserts,
78 Row Privileges,
79 Asynchronous Rowset Processing,
80 Row Threading Model,
81 Server Cursor,
82 Strong Row Identity,
83 Objects Transacted,
84 Unique Rows,
85 Updatability,
86 Batch Size,
87 Update Criteria,
88 Background Fetch Size,
89 Initial Fetch Size,
90 Background thread Priority,
91 Cache Child Rows,
92 Maintain Change Status,
93 Auto Recalc,
94 Unique Table,
95 Unique Schema,
96 Unique Catalog,
97 Resync Command,
98 Cursor Engine Version,
99 Reshape Name,
100 Update Resync,
101 Release Shape On Disconnect,
102 Bookmarkable,
Database Type Microsoft Access (mdb)
0 Preserve on Abort,
1 Blocking Storage Objects,
2 Use Bookmarks, False
3 Skip Deleted Bookmarks, False
4 Bookmark Type, 1
5 Cache Deferred Columns, 0
6 Fetch Backwards, 0
7 Hold Rows, True
8 Scroll Backwards, True
9 Column Privileges, False
10 Preserve on Commit, False
11 Defer Column, True
12 Delay Storage Object Updates, 0
13 Immobile Rows, (none)
14 Literal Bookmarks, False
15 Literal Row Identity, 2
16 Maximum Open Rows, 0
17 Maximum Pending Rows, 31680
18 Maximum Rows, False
19 Column Writable, True
20 Memory Usage, True
21 Notification Phases, 2
22 Bookmarks Ordered, True
23 Others' Inserts Visible, True
24 Others' Changes Visible,
25 Own Inserts Visible, False
26 Own Changes Visible, 3
27 Quick Restart, True
28 Reentrant Events, True
29 Remove Deleted Rows, True
30 Report Multiple Changes, True
31 Row Privileges, 3
32 Row Threading Model, False
33 Objects Transacted, 0
34 Updatability, 0
35 Strong Row Identity, True
36 IAccessor, 0
37 IColumnsInfo, 0
38 IColumnsRowset, True
39 IConnectionPointContainer, False
40 IRowset, 0
41 IRowsetChange, 24
42 IRowsetIdentity, 24
43 IRowsetInfo, False
44 IRowsetLocate, 0
45 IRowsetResynch, 0
46 IRowsetScroll, True
47 IRowsetUpdate,
48 ISupportErrorInfo, False
49 ILockBytes, False
50 ISequentialStream,
51 IStorage, False
52 IStream, True
53 IRowsetIndex, False
54 Column Set Notification, False
55 Row Delete Notification, True
56 Row First Change Notification, True
57 Row Insert Notification, True
58 Row Resynchronization Notification, True
59 Rowset Release Notification,
60 Rowset Fetch Position Change Notification,
61 Row Undo Change Notification,
62 Row Undo Delete Notification,
63 Row Undo Insert Notification,
64 Row Update Notification,
65 Append-Only Rowset,
66 Change Inserted Rows,
67 Return Pending Inserts,
68 IConvertType,
69 Notification Granularity,
70 Access Order,
71 Lock Mode,
72 Server Data on Insert,
73 IRowsetCurrentIndex,
74 Jet OLEDB:Validate Rules On Set,
75 Jet OLEDB:Fat Cursor Cache Size,
76 Jet OLEDB:Enable Fat Cursors,
77 Jet OLEDB

artial Bulk Ops,
78 Jet OLEDB

ass Through Query Connect String,
79 Jet OLEDB:ODBC Pass-Through Statement,
80 Jet OLEDB:Grbit Value,
81 Jet OLEDB:Use Grbit,
82 Jet OLEDB:Stored Query,
83 Jet OLEDB:Locking Granularity,
84 Jet OLEDB:Bulk Transactions,
85 Jet OLEDB:Inconsistent,
86 Jet OLEDB

ass Through Query Bulk-Op,
87 Bookmarkable,