I am developing a MS ACCESS application for a client that has non-stable network.
The application is split into front-end (on Client PC) and back-end (on LAN).
I use mostly unbound forms to minimize connection time to the back-end database (MS ACCESS as well).
My goal is to decrease chances of database corruption when network connection is not stable.
However, in some cases I have to use sub-forms to display search results.
I would use a list-box control, but it has a limit of 1000 rows (or I need to increase the limit value based on number of records in a result-recordset, which is not convenient).
Does anybody know which type of recordset in MS Access Forms (Dynaset, Dynaset-Inconsistent Updates, Snapshot) is the best to use to decrease chances of database corruption when network connection is not stable?
Do “Record Locks” (No locks, All records, Edited record) and “Allow Edits” properties have any effect to stability of an application?
Your help is appreciated.
Sudakov
The application is split into front-end (on Client PC) and back-end (on LAN).
I use mostly unbound forms to minimize connection time to the back-end database (MS ACCESS as well).
My goal is to decrease chances of database corruption when network connection is not stable.
However, in some cases I have to use sub-forms to display search results.
I would use a list-box control, but it has a limit of 1000 rows (or I need to increase the limit value based on number of records in a result-recordset, which is not convenient).
Does anybody know which type of recordset in MS Access Forms (Dynaset, Dynaset-Inconsistent Updates, Snapshot) is the best to use to decrease chances of database corruption when network connection is not stable?
Do “Record Locks” (No locks, All records, Edited record) and “Allow Edits” properties have any effect to stability of an application?
Your help is appreciated.
Sudakov
