Updating a Sql database from an Access linked table

[jfrench1941]

I am somewhat new to Access but I kow Sql server. I have an Access table linked to a Sql server table. I want to update on certain fields in the sql table.

I have created a query : with the fields I need updated
SELECT Invoice.invoice_num, Invoice.invoice_date, Invoice.[TOTAL PAID]
FROM Invoice;

can I write a stored procedure that will run this qurerry and update only these fields in my sql server database. I am using sql server 2000

I guess I would want to run the query connect to sql server and update the table? Can someone help. Thanks

[PianoMan64]

The easist way to deal with this issue is to write an update query. This would be the simplest way to update your values in MS SQL.

I'm assuming you already know how to do that SQL, you can use the same syntax in MS Access, or you can use the Query builder in Access to create a select query and then change the Query type from Select to Update, and then select where the Update values are coming from, and that's it.

If you need more detail, please include SQL Example.

Thanks,

Joe P.

[NeoPa]

If your Access table is already linked to the SQL Server then you can simply treat it like a normal Access table (by and large). How you update it depends mostly on what type of updates you want to apply.

You can update manually, you can write a procedure linked to a form control (for instance), you can write an UPDATE query even.