Results 1 to 5 of 5
  1. #1
    byterbit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Oct 2010
    Location
    Noou Yauk
    Posts
    32

    Appending to table fails with VERY odd message

    Appending to table fails with VERY odd message



    Trying to append to a table fails with pop up message : “Nobody is that fast”

    I’ve compacted and repaired, and then made a new MDB and moved all tables into it. This MDB is a simple back end with only tables.
    It was built in 2003 but now runs under 2010
    I didn’t know you can have insert triggers in Access ( that’s a bad joke; I have no idea what is causing this or how)

    This is happening on the lowest level I can work on; I go into the table directly and try to add a record. No forms, no macros, no VBA code involved.

  2. #2
    hapm is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    197
    Perhaps its a validation message for a none matching validation rule. Check the column definitions in the design view of the table.

    EDIT: removed pointer to data macros, as this is access 2003

  3. #3
    byterbit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Oct 2010
    Location
    Noou Yauk
    Posts
    32
    Hapm, you were right. I never use table based validation rules myself, so I had no idea.
    (Someone had placed a rule in a table on a numeric field that holds times to do a test. If the number was too
    low it gave that error message.)
    Thanks !

  4. #4
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Sorry - I posted before I saw your update.

    Does anyone know if or how a posting can be deleted?

    Tks - John


    You could do a global search (entire database) on all your VBA code for that string.

    However, considering that you are getting that strange message error even at the table level, my suspicion is that you have malware or that Access itself has an "issue".

    My suggestion is to try a reinstall of MS Access (from a reliable source) to see if that clears it up.

    HTH

    John
    Last edited by John_G; 05-20-2014 at 11:01 AM. Reason: No longer applies!

  5. #5
    byterbit is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Oct 2010
    Location
    Noou Yauk
    Posts
    32
    John:

    That was just what I thought it was too.
    (But I've only been programming in Access since 1996, so I have a lot yet to learn.)

    Thanks !

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-05-2013, 12:09 PM
  2. Appending records to a table
    By crowegreg in forum Programming
    Replies: 6
    Last Post: 08-13-2013, 09:54 AM
  3. Message before Appending Records
    By Lorlai in forum Programming
    Replies: 3
    Last Post: 03-19-2013, 04:51 PM
  4. Appending the Null Values to One table
    By Jerseynjphillypa in forum Queries
    Replies: 5
    Last Post: 05-17-2012, 02:01 PM
  5. Newbie needs help appending table
    By hara in forum Queries
    Replies: 6
    Last Post: 06-30-2010, 05:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums