jjnet123
asked on
Issue accessing a linked excel spreadsheet from Access
Hi,
I've developed a DB in Access and deployed using Access Runtime to a network. As part of it's daily routine a spreadsheet (xls) is downloaded and I use VBA/SQL/ADO to extract the latest information from it.
For 1.5 years, it's been working flawlessly - however yesterday it stopped working. Regardless of any downloading etc, if I even attempt to connect to the Excel spreadsheet I get the following message:
"The Microsoft Office Access database engine cannot open or write to the file {filepath}. It is already opened by another user, or you need permission to view and write its data."
I can open and change the file without any issues.
I do exactly the same thing with a CSV in exactly the same location and it still works perfectly.
The issue is present on every machine on this network, but I can't replicate it on my own system (although I'm using full Access rather than ART).
I'm stuck, help!
I've developed a DB in Access and deployed using Access Runtime to a network. As part of it's daily routine a spreadsheet (xls) is downloaded and I use VBA/SQL/ADO to extract the latest information from it.
For 1.5 years, it's been working flawlessly - however yesterday it stopped working. Regardless of any downloading etc, if I even attempt to connect to the Excel spreadsheet I get the following message:
"The Microsoft Office Access database engine cannot open or write to the file {filepath}. It is already opened by another user, or you need permission to view and write its data."
I can open and change the file without any issues.
I do exactly the same thing with a CSV in exactly the same location and it still works perfectly.
The issue is present on every machine on this network, but I can't replicate it on my own system (although I'm using full Access rather than ART).
I'm stuck, help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER