Access 2007 Update query not behaving

G

GE2V

As an experienced Access user I 've just started using v2007 and was very
surprised to see that an update query like this did not work...
update tableA set fieldX = "ABCD"
where exists
(select * from FindDuplicatesQuery F where F.Field1 = TableA.Field1 and
F.Field2 = TableA.Field2 and F.Field3 = TableA.Field3)
and FieldX is null

It updated the matches based on two of the fields rather than 3. I thought
my syntax was wrong so changed the update part to a "select *" clause and the
correct records were displayed. The FindDuplicatesQuery was based on tableA
and the three fields were those in the group by of the query.

Has anyone seen anything like this in Access 2007?
 
A

Allen Browne

Have you applied Service Pack 1 for Office 2007?

If so, and a compact/repair does not avert the problem (just in case it's a
bad index), I am interested in seeing this issue. Are you able to email a
sample database with the 2 tables and the query that illustrates the
problem?

My email is munged, so don't hit reply: decode it from the signature below.
Attachment needs to be <5MB zipped. Include this thread in the email.

If you need SP1, the link is:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top