By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,232 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

ODBC Sage Line 100

P: n/a
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

--
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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;
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.