Solved

Access and SkyDrive

Posted on 2013-05-18
3
527 Views
Last Modified: 2013-05-19
Does anyone have experience running an Access database over SkyDrive?  If so, what is involved?  Can an existing database be converted to run via SkyDrive?  Complications?
0
Comment
Question by:SteveL13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 250 total points
ID: 39177367
Access is a LAN Application. It requires a locking file to be created in the same folder to edit data.

Everyone that I know that has use skydrive  has to download the database. make changes. upload the updated database back to skydrive. This means that is will not be multi-user in real time.




.
0
 
LVL 10

Assisted Solution

by:Luke Chung
Luke Chung earned 250 total points
ID: 39178479
SkyDrive is a cloud hard disk but it is not designed for sharing the internals of a file in real time the way a multiuser Access database requires.

The best way to use SkyDrive is to download the Windows app to your PC, run it, and create a local SkyDrive folder. I make sure all my files are created on my SkyDrive folder. The files get automatically replicated/backed up on SkyDrive in the background (there's a delay). It may help with using the same file across PCs, but not simultaneously.

Hope this helps.
0
 

Author Comment

by:SteveL13
ID: 39178535
Thanks to both of you.  It sounds like I need a different solution.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question