i am trying to update a table i created in an access database. i have one 
page that is able to add records to the page, but i cannot seem to update 
the record. i took an example from microsofts quick tutorial page, but the 
tutorial uses SQL server. i thought that i could write an 'update' sql 
statement and switch it with the 'insert' statement from the add records 
page, but leave the rest of the code alone. the 'edit' and 'cancle' works, 
but not the 'update'. if some one can provide a page or an example on how 
to update records in an access database using an 'update' statement, i'd 
appreciate it. i think i'm close, i just need one last piece of the puzzle.