Cannot open Access Database 3

[Skittle]

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\

http://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.

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 (.

 

[1angryadmin]

are you using a DSN

 

[Skittle]

Nope. A .udl connection description.
I havn't changed it since I first created it many moons ago.
The Advanced tab settings are ticked on 'ReadWrite' and 'Share Deny None'.

 

[Veep]

Check and see if there is a C:\Inetpub\wwwroot\Phones\Phones.ldb file out there. If your machine crashed the .ldb file could still be alive in which case open and re-close the database. If that doesn't make it go away then delete it.

 

[Skittle]

Sadly not the case. No .ldb in sight.

 

[100dtl]

Try properties/security on the folder

 

[TwoOdd]

Try this when making your connection:

'Create Object
set conn = Server.CreateObject("ADODB.Connection&quot
conn.mode = 3 'adModeReadWrite
'Open the connection
conn.Open "DSN"

Good Luck

TwoOdd
--------------
Good judgment comes from experience, and experience comes from bad judgment.
-- Barry LePatner

 

[Skittle]

Still stuck.

I tried TwoOdd's method using a seperate Access database in a seperate location and I still get the same error.
The code is as follows:-

<%
Dim objConn

'
' Define Secure Socket Path
Set ObjConn = Server.CreateObject(&quot;ADODB.Connection&quot
objConn.mode = 3
objConn.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\

http://wwwroot\test1

\test1.mdb;Mode=ReadWrite|Share Deny
None;Persist Security Info=False&quot;
strSQL = &quot;SELECT strTestField1, strTestField2 &quot; & _
&quot;FROM test1&quot;
%>

The Error is:-

Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'C:\Inetpub\

http://wwwroot\test1\test1.mdb'.

It is already opened exclusively by another user, or you need permission to view its data.

This has to be an IIS/Access issue although I can't see where. DESPERATE FOR HELP!!!!

 

[Skittle]

Sorted it.

The problem related to the security tab which you get when you right click a file or folder. In XP I was not getting the security tab. I assumed this was something that you just did not get with XP. I was wrong.

If you go into Explorer--->Tools---->Folder options---->View

You get an option to select 'use simple file sharing'.
With it ticked you do not get the security tab!!!!
It was ticked!!

So with that setting changed I got the security tab and could set the folder and objects up correctly.

Easy when you know how ( sobs quietly in the corner ).