-
pl. help me, i am new to VB.
i request u to suggest me which lock type and i want to open a recordset with dynamic/keyset etc., for database application (around 50000 records database)connected 10 users to SQL server to update/search/delete the records etc., (clinet server technology).
thanks in advance.
-
Personally I use these rules;
1. If the recordset is to be opened for 'lookup' lists etc, ie Read Only with no updating I use adOpenStatic.
2. If the recordset is to be opened for editing, and the recordset has a primary key, I would use adOpenKeyset
3. If the recordset is to be opened for editing, but does not have a primary key, use adOpenDynamic