another access connection thread

Hi Guys,

I'm sure lots of people have posted about this issue so, I apologize in advance if someone has posted a similar thread; I am having issues connecting to MS Access with ASP. The system I have in place was working fine for about 6 months, until a couple weeks ago when it all went to hell. One day it just stopped working, giving me an error about Volitile Jet Processes. I thought maybe someone played around with the permissions for the IUSR, and still that didn't fix anything. I even tried setting the IUSR as an administrator for a minute just to make sure. I tried changing the driver from the MS Access driver, to the OLEDB driver. Still no beans. Right now it is set up as a DSN-less connection, so I tried creating a DSN to connect to the file, and it still doesn't work right. The last thing I have tried was re-copying the access file from where I got it, to make sure it wasn't corrupt. This is the connection string I am using:

MyConnA.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"

And this is the error I am getting:

Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

Also, the system works perfectly on our development server, which is Windows 2000 (Our live server is windows server 2003). I have the exact same system set up on another Windows 2003 box, and it works THERE too. So it is not a platform issue. It is just this particular server that broke. The only thing that has changed in the past couple weeks on this server is that PHP 5.0 was installed, but I don't see how that could affect this.

I have been trying to figure this out for a couple weeks now, and I am completely out of ideas. Any sort of ideas would be greatly appreciated.

Totally stumped.
-mungu

Hello,

We are having the same problem.. if you find a solution let us know.


Thanks,

Jason