ODBC Sage Line 100

[Frank Murren]

I have created a ODBC link with SAGE Line100 and a standard Access 2002
dbase.
I have created a table (and then a query based directly on that table) using
fields from the external data.This data is continuously updated during the
day.
When I run the query, the records are obtained but are then non-updatable.
I want to add a single additional piece of information (from a lookup table
I have created in my database) to each record imported from the external
data by using a simple data entry form.
This data entry form will be used to update records on a daily basis.
I think the answer lies in action queries but I have no real working
knowledge of these and so need plenty of guidance.
Can anyone help me with a simple solution on this.
Thanks to any reply--
frank

--

[Pieter Linden]

"Frank Murren" <fr***@cm-p.fsnet.co.uk> wrote in message news:<bn**********@news6.svr.pol.co.uk>...

I have created a ODBC link with SAGE Line100 and a standard Access 2002
dbase.
I have created a table (and then a query based directly on that table) using
fields from the external data.This data is continuously updated during the
day.
When I run the query, the records are obtained but are then non-updatable.
I want to add a single additional piece of information (from a lookup table
I have created in my database) to each record imported from the external
data by using a simple data entry form.
This data entry form will be used to update records on a daily basis.
I think the answer lies in action queries but I have no real working
knowledge of these and so need plenty of guidance.
Can anyone help me with a simple solution on this.
Thanks to any reply--
frank

--

So look up UPDATE QUERY or something like it in the help!

UPDATE MyTable
SET MyTable.Textfield = "Something",
MyTable.NumericField = 12,
MyTable.DateField = #5/1/2003#
WHERE MyTable.ID=12;