Update Query Corruption causing headache

C

Craig McLaughlin

I have a simple update query in an Access 2000 database. Everytime I set
the query up it runs fine providing I dont re-open it in design view - it
remains ok. However the moment I reopen it in the design view it changes
the fields like so

This Field - IntendVote - is changed to this - Expr1:
TA-Supporters.IntendVote

Every other update field is auto corrected also. I have switched off the
Auto rename feature but the problem still persists can anyone help cause it
is giving a big headache and I can't find anything about it on google

Thanks

Craig
 
J

John Vinson

I have a simple update query in an Access 2000 database. Everytime I set
the query up it runs fine providing I dont re-open it in design view - it
remains ok. However the moment I reopen it in the design view it changes
the fields like so

This Field - IntendVote - is changed to this - Expr1:
TA-Supporters.IntendVote

Every other update field is auto corrected also. I have switched off the
Auto rename feature but the problem still persists can anyone help cause it
is giving a big headache and I can't find anything about it on google
Click to expand...

Have you switched off Name Autocorrect (Tools... Options... General...
uncheck Track Name Autocorrect Information)? It's very buggy and
notorious for causing this kind of corruption. You should probably
Compact the database after unchecking it, if you have not already done
so.

John W. Vinson[MVP]
 
C

Craig McLaughlin

Yes I have turned off the autocorrect and compacted it but the problem
continues

Craig
 
G

Gary Walter

Is the name of your table

TA-Supporters

what happens if give the table an alias
in query design?

I wonder if (w/o brackets around
table name) if Access is not thinking
you are subtracting?
 
C

Craig McLaughlin

Possibly but I enclosed the field reference in brackets but as soon as I
enter Access separates the data into the table and field columns of the
query.

Craig
 
J

John Vinson

Possibly but I enclosed the field reference in brackets but as soon as I
enter Access separates the data into the table and field columns of the
query.
Click to expand...

I'm sorry, but I've read that sentence several times and I still have
no idea what you mean. "Separates the data"????

I would strongly suggest renaming the Table (not the field) so that
the name does not contain a hyphen - character. Replace it with an
underscore _, or just rename the table to TASupporters. You'll need to
change the references in the query as well. In my experience, using
special characters in tablenames is risky; hyphens are particularly
problematic.

John W. Vinson[MVP]
 
Top