 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / March 2008Access database is not creating the lock file when access from an asp web apps
I'm running Access 2003 on Windows Server 2003, and I'm also running a asp web application on that server that access my Access server via Jet. Unfortunately the .ldb lock file is not being generated when access my application online, therefore only one user can access it and it's not updatable. And I keep getting the following error message: Error information: Microsoft JET Database Engine (0x80004005) Could not use ''; file already in use. I gave all the proper permission to the internet user account (IUSR), but with no success. Please help! > I'm running Access 2003 on Windows Server 2003, and I'm also running a > asp web application on that server that access my Access server via [quoted text clipped - 9 lines] > I gave all the proper permission to the internet user account (IUSR), > but with no success. This is ALWAYS a permissions problem: you have not granted Modify permissions for the _folder_ containing the database file to all users of the database. There are several ways for this to happen: 1. You haven't realized that folder-level permissions are key (all users need to be able to create, modify and delete that ldb file, which requires folder level permissions) 2. You have granted authority to the wrong users. a. if your site does not have anonymous enabled, then another user account is being used b. your site may be configured to use a different account from the IUSR account c. your site is running in isolated mode, or your code to access the database is in global.asa, either of which require the IWAM account to be granted permissions  SignatureMicrosoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.