update query error

[Bob Hughes]

I'm trying to run a simple update query with access 2K

UPDATE TblStock INNER JOIN QryNewStock ON TblStock.StockNumber =
QryNewStock.StockNumber SET TblStock.Quantity = [qrynewstock].[quantity];

And get this error

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

Does anyone know what could be causing this error? QryNewStock is based on
a link to a text file.

Bob

 

[Bob Hughes]

I'm trying to run a simple update query with access 2K

UPDATE TblStock INNER JOIN QryNewStock ON TblStock.StockNumber =
QryNewStock.StockNumber SET TblStock.Quantity =
[qrynewstock].[quantity];

And get this error

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

Does anyone know what could be causing this error? QryNewStock is
based on a link to a text file.

Bob

When I imported the text data into the DB, this query runs fine

UPDATE TblStock INNER JOIN TblAAIC9028 ON TblStock.StockNumber =
TblAAIC9028.StockNumber SET TblStock.Quantity = [TblAAIC9028].[quantity];

It would be easier just to link to the file, but its only going to be done
1 more time
Bob

 

[prabha]

Hi Bob,

See:
Your Update Query or Your Delete Query Fails If the Query Reads Data from a
Linked Text File
http://support.microsoft.com/default.aspx?scid=kb;en-us;824159

Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| Subject: update query error
| From: Bob Hughes <[email protected]>
| Organization: Your Company
| Message-ID: <[email protected]>
| User-Agent: Xnews/5.04.25
| Newsgroups: microsoft.public.access.queries
| Date: Tue, 24 Feb 2004 11:52:09 -0800
| NNTP-Posting-Host:
cpe0080c828953d-cm400026328287.cpe.net.cable.rogers.com 24.112.215.210
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.queries:191279
| X-Tomcat-NG: microsoft.public.access.queries
|
| I'm trying to run a simple update query with access 2K
|
| UPDATE TblStock INNER JOIN QryNewStock ON TblStock.StockNumber =
| QryNewStock.StockNumber SET TblStock.Quantity = [qrynewstock].[quantity];
|
| And get this error
|
| "Updating data in a linked table is not supported by this ISAM"
|
| Does anyone know what could be causing this error? QryNewStock is based
on
| a link to a text file.
|
| Bob
| --
| TO reply via e-mail, change the xxx in the address to bob_
|

 

[Bob Hughes]

Amazing! I've just been lucky up to now. Have only used INSERT with linked
text file.
Thanks for the information.
Bob
(e-mail address removed) ("prabha") wrote in