Error on insert: "Invalid input parameter values"

Discussion in 'Microsoft Access VBA Modules' started by Guest, Oct 24, 2007.

  1. Guest

    Guest Guest

    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.

    TIA,
    Joel
     
    Guest, Oct 24, 2007
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Paul Janofsky

    Syntax error in "insert" statement

    Paul Janofsky, Aug 13, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    201
    John Spencer (MVP)
    Aug 13, 2003
  2. Tom

    INSERT INTO syntax error

    Tom, Sep 3, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    208
    Scott McDaniel
    Sep 3, 2003
  3. nate

    insert error

    nate, Sep 4, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    216
  4. bob

    insert query on recordset error?

    bob, Dec 4, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    168
  5. bob

    insert query error

    bob, Dec 4, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    3
    Views:
    171
  6. bob

    multi field recordset insert error

    bob, Dec 8, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    5
    Views:
    288
    Dirk Goldgar
    Dec 10, 2003
  7. Guest

    Insert records and then return ID to insert into sub table

    Guest, Jun 11, 2007, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    979
    Allen Browne
    Jun 11, 2007
  8. bchase

    Run-time error 3134, Syntax error in INSERT INTO statement

    bchase, Apr 16, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    2
    Views:
    1,326
    Klatuu
    Apr 16, 2008
Loading...