Question Locked

Link Access DB to Excel Spreadsheet that's open by another user

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,
I'm using Office '03 and am trying to link an Access DB to an Excel spreadsheet. The problem is that if the spreadsheet is opened by another user and I attempt to access the spreadsheet via the linked "table" I receive "The Microsoft Jet database engine cannot open the file '...' It is already opened exclusively by another user, or you need permission to view its data."

If I go directly to the spreadsheet I'm told the file is locked for editing but I can select read-only and view the contents without a problem. If no one else is viewing the Excel sheet Access doesn't have any problems.

How can I either prevent Excel from locking this file or have Access open in read-only mode (although I understand Access links to Excel are always read-only by design anyways).

Thanks in advance!
Jeff

4 replies

by jfowler

Here is the problem Jeff, Excel, will not, by any means, let more than one person write to it at the same time. That is why you keep getting the errors. Someone else on the network is acessing the sheet. If you want to stop this, add the excel sheet to a protected folder. Only allow yourself permission to the folder. Or, disallow write access to everyone but yourself to the Excel document. Others may then open it in read only mode, and you will not get the errors when trying to link the mdb.

by jeff.troutman

Thanks guys.
I realize the "issue"... I was just trying to find a way around it as another department uses the spreadsheet (they prefer it for some reason) but I need to have updates populated to my db occasionally.

What I did find however is that if I open the spreadsheet in read only mode (another user already has it open, I open Excel directly, select read-only) I CAN access it via Access as long as I have Excel open on my desktop with that spreadsheet.

Gotta love Microsoft

This discussion is closed to new replies.