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.