Perl (Win32:ODBC) to update records

[Shrp]

I'm trying to use Win32:ODBC to update a series of records
in an Access database. I'm able to use FetchRow to get the
records I want. However, when I try to update those
records, then it only grabs the first of those records
and never fetches any more.

I've been doing variations of something like:

while ($db->FetchRow()) {
$db->Sql("update database set $field1 = value1 where id = $id);
$db->Sql("update database set $field2 = value2 where id = $id);
}

It will update the first record just fine, but doesn't find any others, whereas if I leave out the sql statements,
it finds the ones I want.

Thanks!