Solved

Shareing an access database

Posted on 2014-01-30
6
180 Views
Last Modified: 2014-02-04
I have created a database that links to excel spread sheets.  

If I zip up the database and the excel spread sheets and send them to someone else the database does not work, it says it can not find the files and states a path that is on my computer ( this error message comes from someone elses computer ).


I want to be able to send a copy of my access 2010 database and the linked excel files to another user.  

we do have sharepoint however we do not have control of it and I do not think we have the access database extensions.

How do I send the database and data to my team when we do not have control of the network ( high security )
0
Comment
Question by:TIMFOX123
  • 2
  • 2
  • 2
6 Comments
 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 250 total points
ID: 39823136
With a Win7 machine you can put the Excel files in C:\Users\Public\Documents or WinXP it would be C:\Doucments and Settings\All Users\  folders and then link to them there.

Then when you send the documents the links will be universal. That would be a quick and dirty that should work.

You can also build a whole function to relink the files. It isn't that hard. But the answer depends on what you want to do.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 39823579
Note too that Win7 requires that you put the database in a Trusted Location. If you don't, your code won't run.

Personally, I'd put the files in the same folder and then recreate the link at startup, as Jim P. suggests. That way you always know where the file will be, and can always get to it.

Note too that you generally should not use the [Program Files] folder on a Win7 machine, since UAC will make that folder not writeable. Instead, install your database to one of the Documents folders (either All Users, if everyone needs it, or to a specific User Documents fodler if only one user needs it).
0
 

Author Closing Comment

by:TIMFOX123
ID: 39831380
All good answers but in our locked down  environment Microsoft has made a jail we can not work in.

Well time to reinvent the wheel with a bash script and the join command
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 38

Expert Comment

by:Jim P.
ID: 39831389
Well time to reinvent the wheel with a bash script and the join command.

Sorry we couldn't give you a better answer. But could you import to the backend and link to that?
0
 

Author Comment

by:TIMFOX123
ID: 39831403
Jim

thank you so much for your good reply and the "problem" is not yours.  We are locked down and getting locked down more every day.  

Really can not say more than that.  Just trust me on this :)
0
 
LVL 84
ID: 39832124
Windows 7 UAC has cause quite a bit of frustration, if that's what you're referring to. In many cases, however, it's really just MSFT enforcing "rules" that have been in place for years (but poorly enforced).

A good example is the [Program Files] folder. This was always intended as a "read only" location, but programmers quickly discovered it was read/write, so they dropped everything in there. Access databases require read/write/create/destroy permissions on their host folder, so when UAC locked that down many applications that worked previously began to fail. Not really MSFT's fault, in my opinion, but rather the developer who chose to install their Access database in a location that was not guaranteed to be read/write (and I did exactly that on several installs, and have had to rework my app to work properly with UAC).
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

856 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