|
I have a small access database sitting on an XP machine with IIS 5.1. A set of my ASP pages read and update the database. For some reason I cannot access the data files. This was working fine for months until today when my machine crashed and I ended up installing IIS.
Now I when I navigate to my asp pages to view/update the access database I get the error:-
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the
file 'C:\Inetpub\wwwroot\Phones\Phones.mdb'. It is
already opened exclusively by another user, or you need
permission to view its data.
There is nobody else using the database so it must be a permissions thing.
I have right clicked on the folder holding the database in file manager but can see nothing in the properties that allows the user permissions you get with Windows 2000 server ( 'browsers', authors' etc).
I have looked at the folder properties in IIS and found the 'Home Directory' tab allows read and write. The 'Directory Security tab' has no certificates but does
have 'Anonymous Access' ticked behind'Anonymous Access and Authentication Control' with a username of 'IUSR_' followed by the machine name.
The access database has no users set up in it.
Can somebody please help as this is driving me up the wall...onto the roof and jumping up and down on the guttering hoping it will give way :o(.
|
|
|
Hi
The answer I believe is in the right click on the actual database file itself. There should be a 'security tab - you need to give IUSR_MACHINENAME account write permission on the file. Also make sure the read only tick box is not checked, that can sometimes happen when you upload the database from somewhere else.
Hope that helps
Jeff
|
|
|
Hmmmmm not the case with XP Professional.
The Read Only tick box is there and is unticked but the
security tab is not present. Have you seen the security tab against an object on an XP machione? If you have it would suggest my setup is peculiar.
|
|
|
Hi
If the security tab is not showing, go to the Explorer Tools/Folder Options/View, scroll down to the bottom of Advanced settings and uncheck "Use simple file sharing". That should make the security settings appear.
THanks
Jeff
|
|
|
Thankyou so much!
I have been stuck on this problem for two days and now I feel a bit of a dimwit for not knowing this.
Many, many thanks.
|
|
|
|
|