Lost database connection -
07-02-2004
, 03:57 PM
Hi! I have a problem that has completely stumped me. I have a website that
connects to an Access database. I have been working along on it for weeks.
All of a sudden this morning I was working along, and my page would no longer
come up in the browser. It would just sit there and sit there. Finally I
tracked the problem down to the database connection. If I go to the
"Databases" tab in the Application window, double click my connection, and
click "Test", I get the following error message:
"The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\Databases\PBK_Employees_Tables .mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
I know that nobody else has the database open - there is no .ldb file, and I
even rebooted that machine (the web server) to make sure it didn't think
someone was in it when they weren't. So that leaves it to a permissions issue.
I looked, though, and both myself and the IUSR account still have permissions
to view and modify that folder and that database. So I am completely stumped.
I was originally thinking that my last change to one of the pages in the site
might have caused it: I was going to try to write my own "Update" routine for
a datagrid, and I had changed the name of the OnUpdate event procedure and
created a short procedure just to see if I had captured the event. When I
tried to bring up that page, all the trouble started. However I have gone back
in and undone those changes, and it didn't fix the problem. Plus, I can't
connect to the database from any of the pages in the site - not just that one.
Any ideas would be greatly appreciated. I am at a complete loss.
Thanks,
Christy |