Update Query On Linked Table

[Alan B. Densky]

Hello,

I am trying to update data in a linked table from a linked text file. The
fields match up perfectly. But when I try to run the query, I get the
following error message:

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

I've looked at the Access 2000 install CD, but there is no mention of
ISAM's. I've build update queries before without any difficulty. How can I
overcome this problem?

Alan B. Densky

 

[Rick Brandt]

Hello,

I am trying to update data in a linked table from a linked text file.
The fields match up perfectly. But when I try to run the query, I
get the following error message:

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

I've looked at the Access 2000 install CD, but there is no mention of
ISAM's. I've build update queries before without any difficulty.
How can I overcome this problem?

Alan B. Densky

Access insists that ALL of the tables in an action query be editable. Even
though you are not trying to edit the data in your text file, the fact that it
is a read only table will break the update query.

The driver used to link to text files is an ISAM driver which explains the error
message.

 

[Alan B. Densky]

Thanks Rick. Is there any way around this besides importing to a local
table, and then running the update?

Alan

 

[Rick Brandt]

Thanks Rick. Is there any way around this besides importing to a
local table, and then running the update?

When using the read only table as filtering criteria you can often swtich to
using a subquery instead of a join. When you are using the VALUES from the read
only table as the new values you want to insert or update then importing first
is probably the simplest solution.

 

[Alan B. Densky]

Thanks!

When using the read only table as filtering criteria you can often swtich to
using a subquery instead of a join. When you are using the VALUES from the read
only table as the new values you want to insert or update then importing first
is probably the simplest solution.