not supported by ISAM

[G]

I am trying to run an update query on a table I created in my database.
I want it to be updated from data from a linked table.
I get the following error:

"Updating data in a linked table is not supported by this ISAM"

I'm not trying to update the linked table. I am trying to update the table I
created.

G

 

[John Spencer]

One post the query that doesn't work. (Menu View: SQL and then copy and
paste)

Two: Where is the source table (Excel, Text, etc)

Three: Which table is the destination table and where is it?

If you can't use an update query then some options are:
-- import the source data into a table
-- create a temporary holding table and append records to it
-- try using DLookup against the source to get the value you want

If you do one of the first two options
Once you have done one of the above you should be able to do an update
query.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[G]

The destination table to be updated is in my ACCESS database.
The source data is a linked text file, also on my computer.

The sql for the query is:
UPDATE [tblAll-1] INNER JOIN [10273849-JC_Whitney] ON [tblAll-1].SKU =
[10273849-JC_Whitney].SKU SET [tblAll-1].SALEPRICE =
[10273849-JC_Whitney]![SALEPRICE], [tblAll-1].PRICE =
[10273849-JC_Whitney]![PRICE];

 

[John Spencer]

I don't see anything wrong with this as an update query and I think (I
can't test right now) that using a text file to update a table in an
Access database should work.

Another option is to build a temporary work table and populate it by
using an APPEND query from the text file - basically import the text
file instead of linking to the text file.

Once you have done that you should be able to update your TblAll-1.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================