Re: PC UPDATEusing MS ACCESS 2002

["Evan Harris" <spanner@xxxxxxxxxx>]

Hi

Access 2007 has a "feature" that prevents you doing updates until you've
clicked a button - something like UAC that's what I was asking about. It
will get in the way when trying to bulk updates and the like but not when
you are editing a table directly. When I start I get a message saying
certain content in the database is disabled.

I can only presume your SQL statement is incorrect is you are not getting
that message.

I just created an update query in access to update a column in a table from
another table. The resulting SQL as as follows:

UPDATE NewProducts 
INNER JOIN ProductCategory 
ON NewProducts.ProductCode = ProductCategory.ProductCode
SET NewProducts.[Category] = [ProductCategory].[Category];

Maybe that will help you a bit  more.

I've had come challenges getting SQL syntax exactly right for Access before
- I don't know whether that is me or Access  - but I do find the Query
designed helpful for generating the right SQL.

Regards
Evan Harris



-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of Antonio Fernandez-Vicenti
Sent: Wednesday, 27 May 2009 1:50 a.m.
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] PC UPDATEusing MS ACCESS 2002

I don't quite understand your last questions...

Being signed as system Administrator, I have no other problems with the 
Access database.
Can open it, edit and modifiy in any way the tables: both, the original 
(the one that has erroneous data in some records) and the corrected 
records table, with the new values I would use to UPDATE the first one...
So, no problem whatsoever in editing/modifying both tables.

What do you mean by other SQL tools? In this PC there are no other 
"such" tools. I've used SQL in iSeries, in Delphi, etc. But what does 
that have to do with Access database?

If what you mean is: I could write a Delphi program, read the 
modifications, and for each one do the UPDATE in the original table, 
well, yes, probably I could, but that was out of question when I posted 
my original post: Does Access2002 support the type of UPDATE I would 
use, based on the EXIST I posted in the Subselect???