How do I setup a Microsoft Access Application on One Drive?

I have 2 Microsoft Access databases stored on each user's hard drive.  1 is the application and the other is the data.  When I make a change to the application, I create a zip executable and save it on the server where the user can access and it will unzip to the folder on the hard drive c:\quote templates.  I have 2 issues - the user does not always do the update and our IS department is locking down the c:\ root drive on new computers.  I have spoken with IS and they said I need to try and set up the application on One drive.  I'm very new to One drive and I'm pretty much on my own with this - limited help from IS.  My question is can it work and where do I go to figure out how to set this up?  Is it possible to hire someone through Experts-Exchange to help me?

MarilynSenior Business AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You don' won't work.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
OneDrive is nothing more than a file sharing service, so you could certainly put your zip files there for uses to download and run. However, you cannot "run" an Access app from OneDrive.

IS department is locking down the c:\ root drive on new computers.
You should be installing to either the Documents folder, the AppData folder, or the ProgramData folder. Those are different depending on the OS you're running, but in general one of those would be the right choice for an Access app. ProgramData would be my last choice, since IT is very likely to remove permissions from that, if they're locking down root access as well.

AppData is normally a good choice for these things. The user can get to the folder, edit/add/delete from it, etc. My Documents would be the last choice, since the user would have the ability to easily (and mistakenly) delete the file.
MarilynSenior Business AnalystAuthor Commented:
Thanks for the feedback, I figured that was the answer.  Is there anyway to use onedrive to push the application update to the users?
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Gustav BrockCIOCommented:
Is there anyway to use onedrive to push the application update to the users?

That's what it does by default.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Many use a batch file process to (a) copy a fresh copy of the frontend to the local machine and then (b) load that new local copy. You could do the same with OneDrive, I believe, although I've never tried to do it.
If OneDrive can be mapped as a drive letter, you can use it as the storage location for the FE.

Give the users a shortcut.  The shortcut runs a bat file that copies the FE from the mapped OneDrive folder to the local PC using one of the folders suggested by Scott.

Here's an example.  Change "C:\" to be one of the folders that IT won't lock. I wouldn't just drop the file in there, I would put it in a specific folder as this .bat file does.

md c:\DwgLog
del c:\DwgLog\DrawingLog.accdb
copy "\\BSCCTIMBERLINE1\Timberline Office\AccessApps\Data\CommonFE\DrawingLog.accdb" c:\DwgLog

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MarilynSenior Business AnalystAuthor Commented:
Ok, I can map to one drive if I have the users windows login.  I know how to get it using vba.  But is there a way to setup a variable in batch files (it has been a long time since I done one).  The path is c:\users\Userid\OneDrive
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use environment variables in a batch file:

Copy %USERPROFILE%\YourDatabase.mdb someotherpath

You can see the variables available to you by opening a CMD prompt and type "set" (without the quotes) and pressing enter.
MarilynSenior Business AnalystAuthor Commented:
Thanks, I'm experiencing issues because the directory name has an "accent"


Do you know how I can type the "e" with the accent in the cmd prompt?
MarilynSenior Business AnalystAuthor Commented:
I found the key combinations for the accent over the "e" but I'm not sure how to do it in a batch file
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm not sure how to do that in a batch file. I believe there are commands to convert the unicode to ascii, but I'm fluent enough in batch language to know. If you don't get any additional help, you might post a question that deals with that aspect of the question.
MarilynSenior Business AnalystAuthor Commented:
I figured out how to get the accented e in the batch file by changing the codepage.  But I can't seem to get it to overwrite the existing files - it prompts me in cmd.exe
MarilynSenior Business AnalystAuthor Commented:
I figured it out!

chcp 1252
xcopy "c:\users\%username%\onedrive - mér\Application Files\*" "c:\users\%username%\appdata\local\Quote Templates\application files" /s /i /y
You'll notice in the batch file I posted, I delete the file.  That doesn't raise an error if the file isn't there but trying to write over it will.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.