Update query no longer running

D

Dave

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
 
D

Dirk Goldgar

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.
 
D

Dave

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
 
Top