|
| |
|
|
crissyjo1
Posts: 2
Joined: 7/8/2004
Status: offline
 |
Can't update mdb on another server - 7/8/2004 19:01:42
I have an intranet server that is outside of the domain. Right now I have an mdb on the intranet server that users can update using asp pages. I'd like to place that mdb on the main server (in the domain) but when I do I get the following error.
The Microsoft Jet database engine cannot open the file '\\path\file.mdb'. It is already opened exclusively by another user, or you need premission to view its data.
I've read all of the previous forums and googled 'til my fingers bled. I can't add IUSR to the domain (security issues) but I did add an existing domain user to the intranet server and gave it full rights to the directory and file then made it the anonymous login account. Still doesn't work.
I've edited the global.asa to something like below...
Application(app_ConnectionString)="DRIVER=(Microsoft Access Driver(*.mdb));DBQ=\\path\file.mdb;UID=domain\userid;PWD=password"
I've also tried using a DSN, but this seemed an easier way to play with the whole rights issue. Oh, I've also created the TEMP dir on the IIS server and the anonymous user has full rights to it. Any thoughts?
Thanks for the help, this forum has been a great resource over the past couple of years.
|
|
|
|
ellipisces
Posts: 849
Joined: 12/14/2003
Status: offline
|
RE: Can't update mdb on another server - 7/15/2004 2:05:56
\\path\file.mdb play around with this setting. See what happens...
_____________________________
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
You need to place the .mdb on the web server,
