I have a VB2008 app that we recently converted from VB6. It uses an Access 2000 DB. After completely removing all ADO and replacing with ADO.NET, we seem to be having a frequent problem where some tables in the database are losing their primary key. This may be happening after we compact the database.
Currently we download the database from the customer, open it in Access and restore the primary key.
I have two questions:
1. Is there any way to determine what may be causing this to try to stop it?
2. Is there a way I can programmatically restore a primary key in a table so we don't need to download the demo?