ACCESS FEED: [AccessDevelopers] Error: 3125: is not a valid name. Make sure that it does not include....

Kamis, 18 April 2013

[AccessDevelopers] Error: 3125: is not a valid name. Make sure that it does not include....

Hello all:

Could anyone help me with the following error I am getting when executing an UPDATE query?

is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Here is the piece of code...
....

    sql = "UPDATE USER_TABLE " _
    & "SET locked='Y' " _
    & "WHERE APPUSER_NAME='" & strUserName & "' AND APPUSER_DOMAIN_NAME='" & strDomainName & "'"
    Debug.Print "SQL: " & sql

    Set dbs = CurrentDb
    Set qdf = dbs.CreateQueryDef(sql)

    qdf.Execute

   When copy to the SQL screen it seems to work find.

Thanks,