|29 May 2012||#1|
| || |
Copied MSAccess DB "Loses" Data - There but not viewable. Why?
I am having a problem with copying a MS Access DB (97) from an XP pc to a Windows 7 pc. As more users are forced to "upgrade" this problem is occurring more and more.
If I convert the DB to a new version before copying it, the problem still occurs.
If I rename the extension before copying it, the problem still occurs.
If I compress it before I copy it and then unzip it on the new pc it still occurs.
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?
|My System Specs|
|Similar help and support threads for2: Copied MSAccess DB "Loses" Data - There but not viewable. Why?|
|Changing the "minimize" "maximize" and "close" buttons of a theme||Customization|
|Have copied files named "Copy of" instead of "- Copy" (aka XP style)||General Discussion|
|"Data Manager" stopped working on non-administrative user accounts||General Discussion|
|Outlook 2010 Error message "This data file has not been configured"||Microsoft Office|
|Copy data from "Album" to "Album Artist" using Tag&Rename?||Music, Pictures & Video|
|Media center "loses" video library||Media Center|
|BIOS screen stretches beyond viewable area on 42" HDTV||Graphic Cards|