Or better yet, create a Stored Procedure which will modify the record, then from VB pass parameters (whatever number of parameters you have defined in Stored Procedure) to modify the record. This will increase the speed of your apllication significantly.