Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    4

    Unanswered: Magicaly generating multiple copies of records

    My Access 2000 database is occasionally generating multiple copies of the same record. As if that's not annoying enough, when I try to delete one of the dups, they all disappear.

    Any idea why this is occuring? I'm using ASPRunner to generate the edit and view pages, if that info helps...

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Probably an issue with your interface, not with Access. I doubt that Access is creating duplicate records, and they probably don't even actually exist. Do you have a primary key defined for the table?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2004
    Posts
    4
    Thanks. Any ideas on what ASP coding may be causing the duplicate records? I have also added several new columns/fields to the database. Is that an issue? Thanks again.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I've seen goofy display behavior when interfaces are passed a recordset containing a text or character column with embedded carriage returns. Sometimes displays as additional rows...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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