none
Does anyone have an experience of copying a big mdb file from pc to network? RRS feed

  • Question

  • When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I'm not able to tell by looking at the size of the file. Does anyone have an experience of copying a big mdb file from pc to network?
    Tuesday, September 30, 2014 8:43 PM

Answers

All replies

  • I'd create a new, blank database on the network and then import the objects, a few at a time.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, September 30, 2014 8:53 PM
  • C & R the MDB file locally first, zip/compress the MDB and then copy the zip file to file server.  Unzip the file back to MDB on the file server if required.

    This way, you only need to copy a smaller file (about 20% of the MDB file size) and there are internal checks on the zip file.  If there is any problem/corruption, you will get error when you try to unzp the zip file.

    OTOH, even copying a large file should not corrupt the file consistently.  If you consistently get corruptions, you may have problems in your connection to the file server.

      


    Van Dinh


    • Edited by Van Dinh Wednesday, October 1, 2014 2:04 PM
    Tuesday, September 30, 2014 9:21 PM
  • MDB files have threat go get corrupt so it is advisable to use small files on server. But in the case of mdb file corruption you can use Access Fix Toolbox to get back your corrupt data. http://www.access.fixtoolbox.com/
    Kindly refer to the page for instruction and download of the solution:
    http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/229-copying-1-2-gb-mdb-from-pc-to-network



    • Marked as answer by FinHoodin Saturday, October 4, 2014 1:13 PM
    • Edited by MarkWaters21 Tuesday, October 21, 2014 9:04 PM
    Wednesday, October 1, 2014 7:11 AM
  • Are you, by any chance, trying to copy a file that is in use?
    Wednesday, October 1, 2014 12:42 PM
  • C & R the MDB file locally first, zip/compress the MDB and then copy the zip file to file server.  Unzip the file back to MDB on the file server if required.

    This way, you only need to copy a smaller file (about 20% of the MDB file size) and there are internal checks on the zip file.  If there is any problem/corruption, you will get error when you try to unzp the zip file.

    OTOH, even copying a large file should not corrupt the file consistently.  If you consistently get corruptions, you may have problems in your connection to the file server.

      


    Van Dinh


    The only problem with unzipping is that it is done on the local machine, not the server so you still have the issue of it being copied back to the server again.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, October 1, 2014 3:09 PM
  • Hi Bill

    I wrote "Unzip the file back to MDB on the file server if required." and I meant using the server to unzip the zip file.  AFAIK, every current Windows version (work-station or server) has the "Compress Folder" utility.

     

     


    Van Dinh

    Wednesday, October 1, 2014 3:34 PM
  • Sorry, I misunderstood. Not everyone realizes that if you unzip a file on a server through Windows Explorer you are actually using your local drive to unzip it.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, October 1, 2014 7:31 PM