Update query no longer running

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Since re-linking my tables to SQL Server, I've been getting a runtime 3061
error: Too few parameters. Expected 3.

The code is stopping at the db.execute line straight after the SQL string is
constructed in VBA.

Any ideas?

Cheers,
Dave
 
Dave said:
Hi,
Since re-linking my tables to SQL Server, I've been getting a runtime
3061 error: Too few parameters. Expected 3.

The code is stopping at the db.execute line straight after the SQL
string is constructed in VBA.
Click to expand...

Is it possible that the fields have been renamed in the SQL Server
table, or that you've linked to the wrong table? You'll get that
message any time your query refers to a field name that doesn't exist in
the table.
 
Thanks Dirk.
There had been a field name change as well as a data type change, so quotes
were required in the statement also.
Cheers,
Dave
 
Back
Top