O
O
Oleg Pravdin2019-11-15 09:53:29
SQL
Oleg Pravdin, 2019-11-15 09:53:29

MS Access: Why does the "Invalid Argument" error occur?

Good afternoon, I'm doing a study project on MS Access. There is a table "Listener", the key field (autoincrement) is also called the listener. I am running a query:

DELETE *
FROM Слушатель AS t
WHERE t.[Слушатель] = 24;

..and I get an "Invalid Argument" error. There is line 24 in the database, in other requests [Listener].[Listener] works fine. If you replace DELETE with SELECT, the query works fine (outputs line 24). CHADNT?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
BasiC2k, 2019-11-15
@BasiC2k

I think your case is described here .
namely:
"When naming a field, control, or object, you need to make sure that you do not duplicate the name of a property or other element used by Microsoft Access - this can lead to unintended consequences. For example, if you want to select the value of a field called "Name" in a table NameInfo using the NameInfo.Name syntax, Microsoft Access will display the value of the Name table property, not the value of the Name field."

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question