Excel file as linked table, concurrent access problem (newby question)
Posted on 2003-03-26
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.