Windows Vista Forums

Copied MSAccess DB Loses Data

  1. #11



    Member
    Join Date : Oct 2008
    UK
    Posts : 64
    Vista home premium 64 bit
    Local Time: 01:59 AM
    uk

     

    Re: Copied MSAccess DB Loses Data

    Was only posting for info not for help as problem now solved.


      My System SpecsSystem Spec

  2. #12



    Newbie
    Join Date : Dec 2010
    Posts : 4
    Vista Professional 32 bit
    Local Time: 08:59 PM


      Thread Starter

    Re: Copied MSAccess DB Loses Data

    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?

      My System SpecsSystem Spec

Page 2 of 2 FirstFirst 12
Copied MSAccess DB Loses Data

Similar Threads
Thread Thread Starter Forum Replies Last Post
problems with MSACCESS 2003 agricola Vista General 2 01 Jun 2008
Opening an MSAccess DB bbrewder .NET General 0 07 May 2008
run msaccess macro from PS Immortal_Creations PowerShell 18 07 Apr 2008
Windows Live Messenger loses sign in data on reboot. E Live Messenger 2 17 Nov 2007
Upgrade to Windows Vista from Windows XP loses Outlook Express data files Dave Vista mail 1 23 Oct 2007