Excel file as linked table, concurrent access problem (newby question)

Posted on 2003-03-26
Medium Priority
Last Modified: 2012-06-21
I have read access only to an excel spreadsheet over the network.  I am trying to use this as a read only table.  When someone has this file open, I get the Jet Database error that either I don't have permissions or someone has exclusively opened the file.  It is really annoying because I am able to open the spreadsheet by double clicking on it, i can copy/paste it, etc., but Jet doesn't seem to think it can do it.  Any help would be greatly appreciated.  
Question by:machron1
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

Expert Comment

ID: 8215522
The owner of the Excel workbook must set the shared option at the file level from within Excel.

Menu, Tools, Share Workbook

There are a couple of options at this point,
Allow multi -users to make changes, etc ...

Expert Comment

ID: 8215527
Please note that this is not the same thing as sharing a folder (operating system level)

It must be done from within the file itself.

Author Comment

ID: 8229253
I asked the guy who owns the file to set up tools>share workbook.  He thinks it's going to cause him problems if he "sets up sharing" because of "security concerns" even though I told him that all the permissions will be the same.  That solution probably would have worked, but now I have resorted to creating a file system object, copying that file to another directory, and linking to that file, every single time Access starts up.  what a pain.  

Thanks for the help though.  

Accepted Solution

dotthei earned 200 total points
ID: 8229392
Working from a static copy because of an uneducated control freak is no reason to fret.  You can actually speed up all of your calls to the Excel data now.

Since you won't work the real-time data anyway, don't just copy it to a folder, import it.  Much faster.

Then, setup a "spy", or monitor, back to the uneducated control freak's source file and monitor it for changes.  If it does change, grab it again and and refresh your embedded copy.

To learn how to set up the file spy/monitor
LVL 18

Expert Comment

ID: 9239781
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to dotthei
Please leave any comments here within the next seven days.


EE Cleanup Volunteer

Featured Post

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

Question has a verified solution.

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

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…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

741 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