Sorry for taking so long (516 days) but the problem still exists and is spreading.
The "loss" of data occurs with Windows 7 Premium Home SP 1 but also happened with Vista. The PC in question right now is using Microsoft Security Essentials but the other PCs used various Virus Protection like AVG and McAfee and some had none.
If I open a blank spreadsheet in Excel 2010 and import the data from the Access DB in question I can see all the data in the table. If I open it using VB6 with DAO and ADO I see 3 records from the previous database table that was overwritten when the new one was copied from the external location.
The data is there. I can see it if I open it in Access on an XP machine before I copy it and I can see it using Excel after I copy it to the Windows 7 PC.
Has anyone seen this problem and have a solution for it?