how do i tell the access dbase which row is to be updated.
primary key.<BR><BR>UPDATE tableName SET somevfield = somevalue WHERE id_field = id
if u can explain every term in this string it will be helpful for me.i coud understand only table name.<BR>my primary key is field named Batchnumber.is it the ID?
> my primary key is field named Batchnumber.is it the ID?<BR><BR>is it unique to each record? I can't see your database from where I'm sitting, and you're hardly providing a ton of information here.
Vikrant, what do you think you're doing?
... I would have. now that you've wasted my time I'm not going to bother. fix your own problems.