Solved

web server to access MS Access database on a storage server !?!

Posted on 2006-07-19
9
260 Views
Last Modified: 2013-11-15
I have a website (ASP) using data stored on another server (file-server) and both servers connected to a domain controller.

when i try to open the website I get the message

-----------------------------------------------------------
Microsoft JET Database Engine error '80004005'

The Microsoft Jet database engine cannot open the file '\\10.0.0.23\Databases$\school.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

/include/dbsrecords.inc, line 3
-----------------------------------------------------------

I'm sure it's not under use by any one, so it's a permission case.

what do you think the solution is ?

Thank you for your help
0
Comment
Question by:Data-Base
9 Comments
 
LVL 8

Expert Comment

by:infolurk
ID: 17136582
I think the problem could be caused by any one of a number of issues. If you paste your error message into google and peruse the first ten pages that show up you will get a number of possible reasons and solutions, including a couple of microsoft knowledgebase articles. One link that showed up in my search was http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115 . It looked interesting.

My bet is you have the database set to exclusive, but that is a pure stab in the dark given the information you have provided.

cheers
Steve
0
 

Author Comment

by:Data-Base
ID: 17136623
what kind of information you need!

I have a AD + Storage + Web servers

the access DB is on the Storage Server and the website is on the Web Server.

when I point the website to ms access db file (on the storage server).

I get this message.

is there any thing you like me to provide ?

if I know what is the problem then i would not ask here ;-)

I think it's a sharing permission. but I do not know how exactly i should start check and fix

Thank you
0
 
LVL 8

Accepted Solution

by:
infolurk earned 500 total points
ID: 17136646
From http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306269

CAUSE
There are several causes for this error message: • The account that Microsoft Internet Information Server (IIS) is using (which is usually IUSR) does not have the correct Windows NT permissions for a file-based database or for the folder that contains the file.
• The file and the data source name are marked as Exclusive.
• Another process or user has the Access database open.
• The error may be caused by a delegation issue. Check the authentication method (Basic versus NTLM), if any. If the connection string uses the Universal Naming Convention (UNC), try to use Basic authentication or an absolute path such as C:\Mydata\Data.mdb. This problem can occur even if the UNC points to a resource that is local to the IIS computer.
• This error may also occur when you access a local Microsoft Access database that is linked to a table where the table is in an Access database on a network server.

RESOLUTION
The following items correspond to the previous list of causes: • Check the permissions on the file and the folder. Make sure that you have the ability to create and/or destroy any temporary files. Temporary files are usually created in the same folder as the database, but the file may also be created in other folders such as the WINNT folder. For additional information about how to identify which folder does not have the correct permissions and how to configure temporary files, click the following article number to view the article in the Microsoft Knowledge Base:
253604 (http://support.microsoft.com/kb/253604/) Microsoft Access 97 database connectivity fails in Active Server Pages
If you use a network path to the database (UNC or mapped drive), check the permissions on the share, the file, and the folder.
• Verify that the file and the data source name (DSN) are not marked as Exclusive.
• The "other user" may be Microsoft Visual InterDev. Close any Visual InterDev projects that contain a data connection to the database.
• Simplify. Use a System DSN that uses a local drive letter. If necessary, move the database to the local drive to test.
• Follow the instructions in the following article to work around this problem:
189408 (http://support.microsoft.com/kb/189408/) FIX: ASP fails to access network files under IIS 4.0 and IIS 5.0  

So, if you think its a permissions error, from the above information you should check that you can access the database from the logon and machine that you are trying to view the web page from.

cheers
Steve
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:Data-Base
ID: 17136666
"There are several causes for this error message: • The account that Microsoft Internet Information Server (IIS) is using (which is usually IUSR) does not have the correct Windows NT permissions for a file-based database or for the folder that contains the file."

------------------------------------------------------------------------------------

the IUSR is a local user account in the web server ?

do you think I just need to create IUSR Account in the AD server and then give him the full permission in the database file/folder (Storage Server) and make the Web Server use it instead of the local account ?
0
 
LVL 8

Expert Comment

by:infolurk
ID: 17136675
Possibly, its worth a try anyway. Also check out the information at http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115.

Cheers
Steve
0
 
LVL 84
ID: 17137276
You must provide read/write/create/delete permissions on the folder (on the webserver) housing your Access database to the IUSR Account on the web server. I'm not sure about AD ...
0
 
LVL 4

Expert Comment

by:BrianClark72403
ID: 17138108
Is the website using anonymous authentication or windows authentication?  If using windows authentication, then click on the properties of the webserver computer name in active directory and enable 'trust this computer for delegation.'  That way, when you client PC connects to say:

http://webserver/school/

If the /school directory is set to use NT authentication, the webserver authenticates the client accessing the page and connects up to the storage server AS THE USER CONNECTING TO THE PAGE, instead of connecting to the storage server AS THE IUSR_XXXX account on the webserver.
0
 

Author Comment

by:Data-Base
ID: 17162760
thank you all for your help.

I solved the problem by copying the access files to the webserver and map the folder for the administration personals.

there is some settings problem with the webserver that need to be reinstalled.

"I got help" from a professional company and they said that I need to reinstall the webserver.

I knew that from before, but I hoped that i will not need to do it!

any way, now everything is working as it should be.

next summer I'll reinstall the webserver and try to make things work better.

now I'll go to my summer holiday :-)

Thank you all again
0
 
LVL 8

Expert Comment

by:infolurk
ID: 17164811
Cheers
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

838 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