MS Access error
Posted on 2013-11-12
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?