Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Missing Primary Key

Discussion in 'Information Technology' started by mithridates@gmail.com, Jul 28, 2006.

  1. mithridates@gmail.com

    mithridates@gmail.com
    Expand Collapse
    Guest

    I am creating a database using the OLE JET provider and .NET 1.1. I
    make a copy of a template database and insert rows into various tables.
    The database is closed, copied to another location and used by my
    client application. In a few instances we have noticed that the
    primary key on some of the tables is missing and duplicate rows exist.
    It is possible that this is being caused by the compact database tool,
    but I am not sure just yet. Has any one else had this problem? I need
    some suggestions on where to look for the source of the problem.
    Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    Heritage The curious case of Maharaja's 'missing' painting History of Sikhism Oct 29, 2013
    India Half of the missing children in 2013 remain untraced in India Breaking News Sep 3, 2013
    Note to admin: Missing post Literature Jul 7, 2013
    Malaysia Missing woman found dead Breaking News Jul 3, 2013

  3. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi.

    > In a few instances we have noticed that the
    > primary key on some of the tables is missing and duplicate rows exist.
    > It is possible that this is being caused by the compact database tool


    If you're using Jet's built-in compaction utility, then it doesn't remove
    columns from your table, nor indexes, when it compacts an Access database
    file, so you're barking up the wrong tree if you think this compaction
    utility is allowing duplicate records. If you're using a home grown utility
    to compact the records in the file, then it's defective.

    > Has any one else had this problem? I need
    > some suggestions on where to look for the source of the problem.


    A corrupted Access database file sometimes allows duplicate records in the
    primary key. Create a new Access database file and import the objects, one
    group at a time (first tables, then queries, then forms, et cetera) into the
    new database, except for the problem tables. Create each of these tables
    from scratch in the new database file, ensure that the primary key
    constraint exists on each of these tables, and import the records from the
    corresponding tables in the old database file into the new database file's
    tables. Use this new database file as your template.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    <mithridates@gmail.com> wrote in message
    news:1152106731.132256.292480@p79g2000cwp.googlegroups.com...
    >I am creating a database using the OLE JET provider and .NET 1.1. I
    > make a copy of a template database and insert rows into various tables.
    > The database is closed, copied to another location and used by my
    > client application. In a few instances we have noticed that the
    > primary key on some of the tables is missing and duplicate rows exist.
    > It is possible that this is being caused by the compact database tool,
    > but I am not sure just yet. Has any one else had this problem? I need
    > some suggestions on where to look for the source of the problem.
    > Thanks.
    >
     

Share This Page