MS Access 2003 Autocorrect bug

I think Microsoft sometimes makes mistakes by over‑helping beginners. For example, an Update Query in MS Access 2003. I had to update a record in my table “list_of_computers” with a field named “MS04‑011.” I wrote the query in the following format (SQL View):

UPDATE list_of_computers INNER JOIN data_to_update 
ON list_of_computers.ComputerName = data_to_update.ComputerName 
SET list_of_computers.[MS04-011] = [data_to_update]![MS04-011] 
WHERE ((([data_to_update]![ComputerName])=[list_of_computers]![ComputerName])); 

Then I saved the query and ran it. MS Access displayed an “Enter Parameter Value” window asking for the value of the field “MS04‑11.” While I was thinking about this request, I noticed that Access had changed the field name from:

db.[MS04-011] = data_to_update! [MS04-011]

to

db.[MS04-11] = data_to_update![MS04-011]

I had all Autocorrect options disabled. It seems that Autocorrect still modifies field names when the name looks like a number…


Posted

in

by

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *