No value given for required parameter error when updating access table
Posted on 2008-06-20
I am updating an access table, the table only has two columns, and one row at all times.
Basically it i an old-school way for us to track sessions. When I try and execute the following SQL statement I receive a run-time error stating that No value was given for one or more required parameters.
Update tblEmployeeID Set EmpID=86, EmpPw='Uty33SoWR'
I have also tried it with double qupte around the password