Solved

Access and SkyDrive

Posted on 2013-05-18
3
523 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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

734 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