Hi All,
I currently have a small Access DB and looking for best practice settings in a multi user environment (20 users).
My current settings are...
Default Open View = Shared
Record Locking = No Locks
Other Options (which I'm unsure if relevant)...
OLE/DDS timeout = 30
Refresh Interval = 60
Number Update Retries = 2
ODBC Refresh Interval = 1500
Update retry interval = 250
DDE Operations...
Enable DDE refresh
- but from reading recently one change I should implement to is...
Record Locking = Edited Record?
Kind Regards
I currently have a small Access DB and looking for best practice settings in a multi user environment (20 users).
My current settings are...
Default Open View = Shared
Record Locking = No Locks
Other Options (which I'm unsure if relevant)...
OLE/DDS timeout = 30
Refresh Interval = 60
Number Update Retries = 2
ODBC Refresh Interval = 1500
Update retry interval = 250
DDE Operations...
Enable DDE refresh
- but from reading recently one change I should implement to is...
Record Locking = Edited Record?
Kind Regards