PC Review

Thread Tools Rate Thread

Error on insert: "Invalid input parameter values"

Posts: n/a
      24th Oct 2007
I am working on upsizing our MS Access application to an adp. On only one of
the forms am I having problems: I can update and delete records, but when I
try to insert a record, I get this message:

Invalid input parameter values. Check the status values for detail.

I not been able to isolate it when debugging, and running profiler I do not
see any insert command coming across the wire. This makes it very difficult
to troubleshoot! I did step through debugging, and on the last line that
executes before the error occurs (exit proc) I examined each of the fields in
the recordset. Using those values, I created an insert command and was able
to perform the insert through management studio.

I have found references to this error elsewhere on the web, but no
solutions. Can someone help?

Client: Access 2003/SP2 on Windows Server 2003 Standard/SP2
Server: SQL Server 2005/SP2 Developer Edition (9.00.3042.00) on Windows
Server 2003 Standard/SP2

UniqueTable and Resync properties are set, and the unique table's primary
key (an identity column) is included in the dataset. I'm not completely
certain, but I think that it worked until we moved it to SQL 2005. Database
is running in 9.0 compatibility mode, but changing it back to 8.0 didn't seem
to help.


Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Parameter input with no parameter set up KARL DEWEY Microsoft Access Reports 0 29th Oct 2009 10:01 PM
Re: Parameter input with no parameter set up John Spencer Microsoft Access Reports 0 29th Oct 2009 09:52 PM
error STOP:0x0000007B (parameter, parameter, parameter, parameter) robert35 Microsoft Access Getting Started 1 15th Dec 2004 04:28 PM
parameter query error messages/input masks =?Utf-8?B?Ym1lcnNlcmVhdUB6ZWxsZS5jb20=?= Microsoft Access Queries 0 12th Oct 2004 05:13 PM
Cancelling a parameter input error??? RustyR Microsoft Access Reports 1 21st Jun 2004 08:57 AM




All times are GMT +1. The time now is 05:55 PM.