?
Solved

MS Access error

Posted on 2013-11-12
5
Medium Priority
?
211 Views
Last Modified: 2013-11-24
Situation: an Access 2007 back end database is housed on a web server that is in a DMZ.  It has to be there so a public web page can access it.  Company users who also access it via linked tables each have their own Access front end, some 2010, others 2007.\

Because the back end is in a DMZ, Windows authentication won't work when setting permissions to the directory. We get around this by using a batch file that runs this script to authenticate users:

net use \\webServer\IPC$ /u:webServer\AccessAppUsers passWord

Then a script runs that opens the user's Access front end.

Problem: A few users can open the front end with no problem at the same time.  The rest, regardless of Access version, get this:

The Microsoft Office Access database engine cannot open or write to the file "filename".  It is already opened exclusively by anothere user, or you need permission to view adn write its data.

Our network person tells me the web server would see all users connecting this way the same so directory permissions shouldn't be a issue.

Any ideas why this happens?

Thanks,

McLeanIS
0
Comment
Question by:McLeanIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 58
ID: 39642772
Well now I know why you have a backend in a DMZ.

 Every user needs full read, write, and delete privs for the directory where the DB resides.

 If not, and the first user in does not, then the DB is opened exclusive regardless of settings.

 This includes the account used by the web site, which is a user.

 So your issue boils down to security and is not an Access question per say.   I would double check this is the problem for sure by:

1. Having the user execute the script.
2. Then try:

a. Creating a text file in the directory.
b. Edit the text file and save it.
c. Delete the text file.

 Each user should be able to perform that test without error.

Jim.
0
 
LVL 58
ID: 39642791
and by the way, rather then simply accepting an answer in the other question, you should have stuck with it and made additional comments explaining the situation.

Jim.
0
 
LVL 58
ID: 39642844
I would also not use the ICP$ share, but create a new hidden share.

Make sure the share permissions are set for everyone and full control and that webServer\AccessAppUsers has full privs for the directory.

Jim.
0
 

Accepted Solution

by:
McLeanIS earned 0 total points
ID: 39659747
Due to time constraints, we decided to move the back end database out of the DMZ as a short term fix.  This allowed us to use Windows authentication.  This system needs to be redesigned.  Thank you for the input.  It will help us with coming projects involving the DMZ.

McLean IS
0
 

Author Closing Comment

by:McLeanIS
ID: 39672362
We chose not to spend time testing permissions on files in the DMZ and use a short term fix since we decided parts of this system need redesiging.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

800 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