How do I update a shared Access 2010 database in OneDrive if I don't own the file ?

Posted on 2015-01-21
Last Modified: 2015-01-21

I have shared access to a Microsoft Access 2010 database in OneDrive. The file is owned by another OneDrive user who has given me edit permissions on this file.

When I go into OneDrive I can open the database but it displays the message 'This database is opened read-only. You can only change in linked tables. To make design changes, save a copy of the database.'

If I take a copy of the database as instructed I can amend the database but I can't upload it to the owner's OneDrive.

How can I get around this problem and edit the database 'in situ' as I'm able to with Excel or Word documents ?

Question by:Tocogroup
  • 4
  • 3
  • 2
  • +1
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40562504
You may not be able too, ...a database file is a lot more complex than a spreadsheet or Word document.
Sharing a database file is meant to be for data entry, ...not for "design work"
This is because the DB may already be opened by another user, ...hence you making design changes might result in conflicts/corruption,

If you need to make design changes to a shared database, then you wold need to have a "reference" database, that is not "Live", you can make changes, ...then override the old in situ db, ...

Lets see what other experts may contribute...


Author Comment

ID: 40562524
Thanks Jeff.

What if I don't want to make changes to the design but just add/amend/delete records in the database ? Is that possible ?
LVL 74

Accepted Solution

Jeffrey Coachman earned 250 total points
ID: 40562638
You will have to see the info here:
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40562684
You may do a web search and find this:
However, this company/technology is brand new:
Zap, ...and as such, is not clear if this is reliable or cost effective.
LVL 35

Assisted Solution

PatHartman earned 250 total points
ID: 40562696
No.  One drive and other cloud based sharing services do not work like network folders.  You cannot use this mechanism for updating data in shared databases.

To do what you are asking, you either need to be able to log into the "owner" LAN or to use some other tool such as Citrix or Remote Desktop.

If it is just the two of you, Remote Desktop will be the least expensive alternative although you may need to buy a seat license for yourself (~$100). That will allow you to connect to the "owner's" server and use the app as if he were connecting from the local LAN.  Citrix takes a bit more set up and for two people, you would probably want to use a service bureau since setting up a Citrix server will be expensive.  The service bureau won't be cheap either and will probably end up costing each of you about $50 per month.

Tell us more and we'll try to figure out an option that works for you.
LVL 35

Expert Comment

ID: 40562711
I just went to the Zapier site and found a really scary message displayed on my screen.  Why would zapier want to use storage on my machine??????? Message
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40562819
@Pat, ...
Yeah, ...that site looks a little sketchy...
I just noticed this as I read a bit more...
Zap2...yet the top of the page clearly "appears" to support MS Access...?
Zap 3LOL

BTW, the info in the link I posted seems to imply that opening (and by presumption, ...editing) a shared Access db is possible in with OneDrive.
In  the interest of full disclosure, ...I have no experience with OneDrive (or its predecessor; SkyDrive)
I posted the link simply as an avenue of investigation...

LVL 57
ID: 40562870

<<I just went to the Zapier site and found a really scary message displayed on my screen.  Why would zapier want to use storage on my machine??????? >>

   Many of the file sharing sites cache parts (or all) of a file off-line.

LVL 35

Expert Comment

ID: 40562950
I would not have been concerned if I was signing up for a trial or actually trying to do something.  All I was doing was looking at the website.  There should have been nothing to save on my computer.  Many people don't read these messages carefully and just blow by them which is how malicious software spreads.  Also, the "yes" and "not for this site" don't quite jibe with the question but they are the choices when asked if you want IE to save a password.
LVL 57
ID: 40562957
Yeah, it's down right scary what you find is being done on your computer of the reasons I have tape over my webcams<g>


Author Closing Comment

ID: 40563134
Many thanks to you both, Jeff and Pat.
I've a much better understanding of the issue now. For what I want it for I can devise a 'get around' using Access on a single OneDrive account.Interesting post though !

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 importing text files 13 20
Access 2003 query lost it's only join 7 26
aggregate query? 4 30
Trying to force an answer in a combobox 7 13
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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.

786 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