Solved

Access and SkyDrive

Posted on 2013-05-18
3
489 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
3 Comments
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 250 total points
Comment Utility
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:LukeChung-FMS
LukeChung-FMS earned 250 total points
Comment Utility
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
Comment Utility
Thanks to both of you.  It sounds like I need a different solution.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now