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…
Leave a Reply