Link to home
Start Free TrialLog in
Avatar of jjnet123
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!
Avatar of jjnet123
jjnet123

ASKER

Just to add, I've tried turning the anti-virus s/w off temporarily. No joy.
ASKER CERTIFIED SOLUTION
Avatar of jjnet123
jjnet123

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial