Insert Error: Column name or number of supplied blah (but it shoul

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

Guest

Access 2000SP3 (.adp)
SQL Server 2000 SP4

Insert Error: Column name or number of supplied values does not match table
definition

That is the error I get when printing a report, it print previews perfectly,
but errors when click print.

The reports data source is a sproc which selects * from View. (this is
required to get paramaters to work).

The report was working fine for 2 years, then I added some needed columns to
the view. The columns do not appear on the report, I did not edit the
report. Now I get the above error, if I revert back to the old view, it
works fine.

I've tried a compact+repair, I've tried creating a new .adp and re-importing
the object.

It's as if Access has a definition of the view and won't update it to the
latest, is there any way I can get it to recgonise that the view has changed
and to deal with it?

Any suggestions would be great as I'd prefer to not have to re-rwrite the
report if possible :)

Thanks.
Steve'o
 
Steve: one question is how you are supplying the parameters by named
parameter or by ordinal, where column order might matter. Secondly, does
the sproc work correctly returning the desired values when you open it using
ADO and supply the parameters that way or do you get the same error?
Third, of course this is a simple work around in the short term is to have
two separate views within the SQL backend, the old one for the report and
the new one for other purposes.
 
Thanks SA.

Parameters are supplied named (@Yeah char(4) = '2004', @PERIOD char(2) = '06')
Yeah the sprocs work fine if I open through ado.

I have done option 3, just used two views. I don't like to do it because it
means maintaining more stuff and its messy, but it works at least :)

Thanks.
 
Back
Top