asked on

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

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.

dotthei

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 ...

dotthei

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.

machron1

ASKER

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.

ASKER CERTIFIED SOLUTION

dotthei

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

1William

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.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer