Windows Vista Forums

Copied MSAccess DB Loses Data

  1. #1



    Newbie
    Join Date : Dec 2010
    Posts : 4
    Vista Professional 32 bit
    Local Time: 02:47 AM

    Copied MSAccess DB Loses Data

    When I copy an Access database to either a new location on the same Vista PC or a folder on another networked PC, the data in the DB is not copied. When I open the copied database all tables are empty. This happens even if I change the extension and copy it. If I try to transfer the file using several different utilities, like LogMeIn or TeamViewer or attach it in an email and send it, the database is empty when opened at the remote location.

    I have added the Everyone Group to the Security to the folder the databases are in as well as changed the Owner to the folder to Everyone Group.

    What is causing this? I have no problem on XP machines but I do have it also under Windows 7. I have several clients running Vista and Windows 7 and I can not copy or transfer the data so I can fix data entry problem or use their data to trace a problem in another folder.

      My System SpecsSystem Spec

  2.   


  3. #2
    Lottiemansion's Avatar

    Senior Member



    Join Date : Sep 2010
    Sheffield
    Posts : 1,880
    Vista Home premium 32 bit (SP2 plus)
    Local Time: 07:47 AM
    uk uk yorkshire

     

    Re: Copied MSAccess DB Loses Data

    Hi,

    First I am not an expert on Access.

    So I found this: - Solved: How to move access database to another computer - Tech Support Guy Forums

    See if any of it is applicable to you?

      My System SpecsSystem Spec

  4. #3



    Newbie
    Join Date : Dec 2010
    Posts : 4
    Vista Professional 32 bit
    Local Time: 02:47 AM


      Thread Starter

    Re: Copied MSAccess DB Loses Data

    Thanks for the tip but it deals with a different problem.

    My problem is not with copying or moving the database, it is that all the data does not copy or move with it. Somehow Vista is stripping the data from the database when it copies or moves it.

      My System SpecsSystem Spec

  5. #4
    Lottiemansion's Avatar

    Senior Member



    Join Date : Sep 2010
    Sheffield
    Posts : 1,880
    Vista Home premium 32 bit (SP2 plus)
    Local Time: 07:47 AM
    uk uk yorkshire

     

    Re: Copied MSAccess DB Loses Data

    OK,

    Sorry that didn't help.

    I will do some more digging for information & possible solutions but for now I have nothing else to suggest.

      My System SpecsSystem Spec

  6. #5
    Lottiemansion's Avatar

    Senior Member



    Join Date : Sep 2010
    Sheffield
    Posts : 1,880
    Vista Home premium 32 bit (SP2 plus)
    Local Time: 07:47 AM
    uk uk yorkshire

     

    Re: Copied MSAccess DB Loses Data

    Hi,

    A couple of questions regarding the coding of cells & data access etc.

    How have you addressed the cells to the data, internal or external to the file?
    Are or the external references transferable to the new machine without recoding them etc?

      My System SpecsSystem Spec

  7. #6



    Newbie
    Join Date : Dec 2010
    Posts : 4
    Vista Professional 32 bit
    Local Time: 02:47 AM


      Thread Starter

    Re: Copied MSAccess DB Loses Data

    The database is self contained. There is one database containing all the data and all the objects like tables and queries. When I copy this database to any new location either local or remote, all the data is lost. Only the data is lost while every object is copied.

    This only happens with Vista and not XP. There is something in the Vista environment that causes this. Maybe a permissions thing or right on the file?

      My System SpecsSystem Spec

  8. #7
    Lottiemansion's Avatar

    Senior Member



    Join Date : Sep 2010
    Sheffield
    Posts : 1,880
    Vista Home premium 32 bit (SP2 plus)
    Local Time: 07:47 AM
    uk uk yorkshire

     

    Re: Copied MSAccess DB Loses Data

    Hi,

    Do a "Save as to the new drive location or just try to save it to public etc. on the networked PC.

    This will transfer the data & software file in a normal way & that could get around the permissions stuff you suspect is causing the problem.

    Worth a try?

      My System SpecsSystem Spec

  9. #8



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

     

    Re: Copied MSAccess DB Loses Data

    This sounds very like the problem I have. Installed Office 2007 after trying out Windows7 and the only Access file (.mdb) I have now is empty on viewing. It states I must open using IE or Access 2003. IE does nothing so have to try to find a copy of Access 2003. In Windows 7 it states that some content has been disabled by a security alert. Allowing the content though still produces nothing.
    The only PC I have with XP hasn't got 2003 on it!!!

      My System SpecsSystem Spec

  10. #9



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

     

    Re: Copied MSAccess DB Loses Data

    Quote Originally Posted by Lottiemansion View Post
    Hi,

    Do a "Save as to the new drive location or just try to save it to public etc. on the networked PC.

    This will transfer the data & software file in a normal way & that could get around the permissions stuff you suspect is causing the problem.

    Worth a try?
    I've tried that with my similar problem, no joy. Everything looks ok until you open up the file and it is empty even though says has 1MB of data in it.

      My System SpecsSystem Spec

  11. #10
    Lottiemansion's Avatar

    Senior Member



    Join Date : Sep 2010
    Sheffield
    Posts : 1,880
    Vista Home premium 32 bit (SP2 plus)
    Local Time: 07:47 AM
    uk uk yorkshire

     

    Re: Copied MSAccess DB Loses Data

    Hello Darrylemaio,

    Could you please post the full system details Windows version, SP etc. especially the Antivirus/ Malware protection software details for the PC's you are trying to copy this Access file to. Also post the system & protection details for the one that the software works on.

    Hello bogart,

    Could you please create your own thread (Orange button) in this forum: -

    Microsoft Office - Vista Forums

    This request is to prevent confusion. We could split off into different solutions or diagnostic paths & will make following the instructions & information too complicated. OK?

    bogart, I have found your thread, link below: -

    Microsoft Access

      My System SpecsSystem Spec

Page 1 of 2 12 LastLast

Copied MSAccess DB Loses Data
Similar Threads
Thread Forum
problems with MSACCESS 2003 Vista General
Opening an MSAccess DB .NET General
run msaccess macro from PS PowerShell
Windows Live Messenger loses sign in data on reboot. Live Messenger
Upgrade to Windows Vista from Windows XP loses Outlook Express data files Vista mail