Marilyn Messineo
asked on
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?
Marilyn
Marilyn
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the feedback, I figured that was the answer. Is there anyway to use onedrive to push the application update to the users?
Is there anyway to use onedrive to push the application update to the users?
That's what it does by default.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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.
Copy %USERPROFILE%\YourDatabase
You can see the variables available to you by opening a CMD prompt and type "set" (without the quotes) and pressing enter.
ASKER
Thanks, I'm experiencing issues because the directory name has an "accent"
bioMérieux
Do you know how I can type the "e" with the accent in the cmd prompt?
bioMérieux
Do you know how I can type the "e" with the accent in the cmd prompt?
ASKER
I found the key combinations for the accent over the "e" but I'm not sure how to do it in a batch file
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.
ASKER
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
ASKER
I figured it out!
chcp 1252
xcopy "c:\users\%username%\onedr ive - mér\Application Files\*" "c:\users\%username%\appda ta\local\Q uote Templates\application files" /s /i /y
chcp 1252
xcopy "c:\users\%username%\onedr
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.
Jim.