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.