Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: Copied MSAccess DB "Loses" Data - There but not viewable. Why?

29 May 2012   #1

Windows 7 Home Premium 32bit
 
 
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 SpecsSystem Spec
.

Reply

 Copied MSAccess DB "Loses" Data - There but not viewable. Why?





Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 02:59 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33