troubleshooting Question

Microsoft Access database permissions - linked tables

Avatar of squeakyloboy
squeakyloboy asked on
ASP
3 Comments1 Solution299 ViewsLast Modified:
Hi there,

Just having a bit of an issue with good old permissions.

I've got an Intranet here that's run under IIS on one computer. Some of the asp pages use a Microsoft Access database that's located on that same computer. This database has some of its own tables, but mostly has linked tables to another Access database on another computer.

The pages are running fine on the web server, but all other computers are getting the dreaded "The Microsoft Jet database engine cannot open the file 'xxx.mdb'. It is already opened exclusively by another user, or you need permission to view its data." error.

I'm a bit confused, as I thought that as long as the IUSR account has the correct permissions on both the remote Access file and the enclosing folder then all would be fine. And seeing as how everything runs perfectly on the web server, which by my understanding is using the same IUSR account that all other computers would be using, then I don't understand why this isn't working.

Love some help, I feel like I'm hitting my head up against a wall.

Thanks,
Chris
ASKER CERTIFIED SOLUTION
Masoudgh

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros