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. Christine Vollberg via AccessMonster.com

    input box invalid use of null error

    Christine Vollberg via AccessMonster.com, May 9, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    6
    Views:
    988
    Christine Vollberg via AccessMonster.com
    May 10, 2005
  2. Guest

    Input value is invalid of the field

    Guest, Jul 14, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    180
    Guest
    Jul 15, 2005
  3. Mike P

    Passing parameter to query without using Enter Parameter window

    Mike P, Dec 15, 2007, in forum: Microsoft Access VBA Modules
    Replies:
    3
    Views:
    734
    Ken Snell \(MVP\)
    Dec 23, 2007
  4. LauraB

    Appending parameter from parameter query to exported filename

    LauraB, Nov 3, 2008, in forum: Microsoft Access VBA Modules
    Replies:
    4
    Views:
    404
    Pendragon
    Nov 3, 2008
  5. Edwinah63

    Running parameter queries from VBA, suppressing parameter prompts

    Edwinah63, May 4, 2010, in forum: Microsoft Access VBA Modules
    Replies:
    4
    Views:
    1,603
    Edwinah63
    May 4, 2010
Loading...

Share This Page