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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error 3061 3
Error 3061 when running update query from code 3
Error 3061 Too few parameters expected 1 - good tested query 4
Run-time error 3061. Too Few Parameters. Expected 2. 2
running VBA code to run Crosstab query 0
Using SQL Query Code in Form Module to Return Record Count 2
Query and SQL 1
Runtime 3061: Too Few Parameters on nested query 1

Top