Access database locked?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26430
Printed Date: 28 March 2026 at 2:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access database locked?
Posted By: Hyarmion
Subject: Access database locked?
Date Posted: 23 October 2008 at 3:06am
|
I am working my way thru the Web Wiz ASP tutorials and am up to the one about adding data to an MS Access database, but when my program attempts to open the ADO coonection I get this error: Microsoft JET Database Engine (0x80004005) The Microsoft Jet database engine cannot open the file 'c:\myhtml\guestbook.mdb'. It is already opened exclusively by another user, or you need permission to view its data. /myhtml/Add_to_Guestbook.asp, line 10 I am using a datalink (i.e a .udl file) rather than a connection string to access the database as that is what I have always done with VB. The "Test Connection" button on the datalink works fine. Can anyone help. |
Replies:
Posted By: 123Simples
Date Posted: 23 October 2008 at 6:37am
|
Make sure the Access file is not ReadOnly
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: Hyarmion
Date Posted: 23 October 2008 at 7:35am
| How exactly do I do that, are you referring to internal Access security or external file security? |
Posted By: WebWiz-Bruce
Date Posted: 23 October 2008 at 9:34am
|
Right click the folder the database is in and choose properties. From the security tab make sure that the computers IUSR account has read, write, and modify permissions.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Hyarmion
Date Posted: 23 October 2008 at 11:19pm
 Actually there is no IUSR listed, but there is a User so I ticked it's write permisssion and everything is working fine now. Thanks very much.
|
Posted By: WebWiz-Bruce
Date Posted: 24 October 2008 at 9:05am
|
Giving all users (which is what you have done) these permissions can be dangerous. You need to add the IUSR_<machine_name> to the permissions for the folder and give that read, write, and modify permission. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |