HighDots Forums  

Lost database connection

Macromedia Dreamweaver Macromedia Dreamweaver Discussions (macromedia.dreamweaver)


Discuss Lost database connection in the Macromedia Dreamweaver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
cctbailey
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.