Solved

Issue accessing a linked excel spreadsheet from Access

Posted on 2011-03-10
2
283 Views
Last Modified: 2012-05-11
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!
0
Comment
Question by:jjnet123
  • 2
2 Comments
 
LVL 1

Author Comment

by:jjnet123
ID: 35093554
Just to add, I've tried turning the anti-virus s/w off temporarily. No joy.
0
 
LVL 1

Accepted Solution

by:
jjnet123 earned 0 total points
ID: 35093780
Ok, problem solved.

It seems as though there's some kind of file lock on the location rather than the actual file. If the file is saved to a different location there's no issue.

No doubt a server reboot would have resolved this also.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question