Re: PC UPDATEusing MS ACCESS 2002

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???