I created a SQL backend for a 2007 Access database using Microsoft 2008 SQL Server Management Studio Import/Export to load the existing Access tables. I created Primary keys or indexes where I thought were needed. I then linked these tables to Access and used existing queries/ forms/reports.
In testing the results from the queries, I noticed some queries were not correct – so I changed some of the indexes and all appeared to be working well.
EXCEPT…..I noticed some records starting missing.
Example: A new cont nr is added to the Contract Master. Cont nr is the primary key. Data is entered into the Inspection table for this contract. A report is run for this contract. Later in the afternoon – this contract nr is missing from the Contract table. This seems impossible since it was not deleted – but it is gone.
Any idea what is going on? Any thoughts are welcome!
In testing the results from the queries, I noticed some queries were not correct – so I changed some of the indexes and all appeared to be working well.
EXCEPT…..I noticed some records starting missing.
Example: A new cont nr is added to the Contract Master. Cont nr is the primary key. Data is entered into the Inspection table for this contract. A report is run for this contract. Later in the afternoon – this contract nr is missing from the Contract table. This seems impossible since it was not deleted – but it is gone.
Any idea what is going on? Any thoughts are welcome!
