Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    100

    Unanswered: error on insert into statement

    hello,

    I am using MS Access 2003.
    My problem is that I keep receiving an error when running an append query on an empty table. The same queries run fine if there is already at least one record in the table.
    Does anyone else know that problem? Is this an MS Access bug? Any ideas how to solve that problem?
    Thanks to everybody!!

    Regards,
    Proximus

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Post the query
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    What is the error message you got?

  4. #4
    Join Date
    Apr 2004
    Posts
    100
    @teddy: the error doesn't depend on the query. I receive it with every insert into statment.
    THe error just says: Micorosoft Access is about to append 0 rows.
    However if there is at least one record in the table the query works fine

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •