ODBC Access sriver error

B

Belinda7237

I have a query linked to a worksheet in excel - i added a field to the query
and when i went to refresh the worksheet to add the additional field I got an
error -

Miscrosoft ODBC Access Driver Too few parameters . Expected 1.

Does anyone know how to resolve?
 
C

Chris O'C via AccessMonster.com

Delete the link to the worksheet and recreate it.

The reason you're getting this error message is that the link info doesn't
change after you create the link, even if the linked table does. Your query
expects a field that wasn't in the original link.

Chris
 

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

sqlite-odbc write conflict 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Error message while opening document 0
Dealing with the error: unable to filter on excel hc home school 0
Problem connecting Access to Oracle 0
Total parameter query and ODBC-call failed 0
Access error 3059 0
TransferSpreadsheet method question 2

Top