/build/static/layout/Breadcrumb_cap_w.png

copying 1.2 GB mdb from pc to network

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?

0 Comments   [ + ] Show comments

Answers (5)

Answer Summary:
Posted by: jefferycarson816 10 years ago
White Belt
1
Click the Windows circle, Access Options (at the bottom right of the menu), Select Customize and change the "Choose commands from:" dropdown to "All Commands", navigate to Compact and Repair Database, click the Add button to add it to the "Customize Quick Access Toolbar" list. Or use Access Fix Toolbox to get back your corrupt data. http://www.access.fixtoolbox.com/
And read:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/229-copying-1-2-gb-mdb-from-pc-to-network
Posted by: aron_chappel 3 years ago
White Belt
0

Well, the DB size is big. If you find the corruption in the database then, restore the database from backup copy. If you want to repair the file by manual way then, follow these steps:

Select File > Info > Compact & Repair Database.

Access creates a copy of the compacted and repaired database in the same location.

Note: If compact and repair is not working then, read this blog: https://www.stellarinfo.com/blog/ms-access-database-repair-when-compact-and-repair-not-works/

Tip: Manually compact and repair a database that is not open

Use this procedure when you can't directly open an Access database.


  • Make sure no other users are currently using the database file.
  • Start Access.
  • In Access 2013, Access 2016, and Access 2019:
  • On the templates page, double-click Blank Database.
  • Select File > Close.
  • Select Database Tools > Compact and Repair Database.
  • In the Database to Compact From dialog box, navigate to and double-click the database that you want to compact and repair.
Posted by: EdT 10 years ago
Red Belt
0
There is no issue I can perceive in copying a 1.2Gb file of any description over a network.  Presumably the file was not in use when copied over. We would need to know more about your network setup to determine if there are any potential issues (eg wireless, hard wired, VPN)

As another test, try opening the local copy of the MDB in access and then use "Save As" to save it to the network location. I believe you will need the LDB file as well but that should be saved at the same time.

What makes you think the file is corrupted?
Posted by: BHC-Austin 10 years ago
4th Degree Black Belt
0
You must be pretty desperate to get this question answered, as you have posted it word for word on quite a few tech forums. I also find it interesting that you tagged it with "repair access database" when your question mentions nothing of repairing, only copying. However, on several of those other tech forums, an "answer" appears to your question that points to a web site selling software that claims to do that very thing...
Posted by: Badger 10 years ago
Red Belt
0
on a real base level... its not permissions on the network share is it???

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ