Recordset lock type

[pravalika]

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.

[Buzby]

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