How does one update an Microsoft Access table from within Sql server. For example: If the sql table has three fields, field1, field2 and field3 and the access table has three fields, Afield1, Afield2 and Afield3. So if field1=1 and field2 =Afield2 update Afield3 with the value in field3. Do In need to link the table into SQL server database or is their someother way. I prefer ot to link the table if I dont have to. Thankin in advance for your help
