Is it possible to run a macro to upload Access DB to a shared drive?

**JasonPsychoSO242** · 12-27-2012, 03:25 PM

Hi,
Every day I have to upload about 10 or 12 databases to a shared drive in case someone has to back me up. When I do this I have to open up twelve separate folders and then drag my copy into a zipfile to overwrite the current DB. I have to do this everyday in case for some reason I'm out or lose my connection. Is there a macro or code I can use in a Access that would allow me to list all the paths and DB's to be uploaded to the shared folder or paths? I know that I can run a macro to download excel documents from SharePoint and can even upload to SharePoint, but what about a shared drive? Any thoughts? Thanks so much!

**alansidman** · 12-27-2012, 05:13 PM

Look here

http://lmgtfy.com/?q=batch+file+to+c...+to+new+folder

A DOS solution

**JasonPsychoSO242** · 12-27-2012, 05:28 PM

Wow seriously??! I don't know if meant to come off the way you did but I know how to use Google.. I wouldn't have used the forum if the answer was that easy.. You should not waste anyone's time posting that crap on here.. If you don't have a good answer or code just don't post anything! Let me clarify... I am not looking for a DOS or command code.
SERIOUSLY???

**alansidman** · 12-27-2012, 05:37 PM

Mr Tactless here again. Suggest you split your db into a FE and BE and share it with your counterparts so you don't have to go through this exercise. Take a look at Bob Larsen's site and look at splitting your db. It is the smarter thing to do. Since you know how to use google, I guess I don't need to give you a leg up and share the link. Good luck with your project.

**davegugg** · 12-28-2012, 02:58 PM

Why not just keep the DBs on the shared drive? If you're copying them their anyway, wouldn't it just pay to keep them there? You could even incorporate alansidman's solution by just moving the front or back end to the shared drive, depending on your needs.