Member Avatar for tommytx

I have a windows 2000 server that was working just fine, until all of a sudden it won't let me update or add records to any microsoft data base mdb that I have on the server. It comes back with Permission denied, so I tried to write a simple text file using asp and could not write that either. It Reads both the mdb and the text file just fine, and I can manually edit the text file or mdb and that works fine also. No matter how I try to write to the server, negative results. I went thru all the steps that are listed to give permissions and I gave everybody and every thing full permission. Still negative results. Does anyone have any idea what I might check to correct what appears to be a permission problem.
The confusing part is that it was working fine for months, I have not recently added any security changes or updates.
Here is the actual error message I am getting, they are different, but I am sure it is due to the inability to write to the server.
When trying to write a simple text file I get 800a0046 Microsoft VB script runtime error. Permission denied. (I have no VB script in this asp file.)
When trying to update or add to the .mdb I get 80004005 Microsoft Jet Database Engine error. Operation must use an updateable query.

I will be forever grateful if anyone has any ideas at all that might shed some light on this dark tunnel.

Thanks in advance
Tom Chambers

  • 4 Contributors
  • 3 Replies
  • 239 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by dexterz

Dani AI

Generated

Short diagnosis and what to check first — this almost always comes down to which Windows account IIS is using and whether that account has the correct NTFS permissions on the folder that holds the .mdb (Jet must create a lock file there). On Windows 2000 / IIS 5 the anonymous web account is IUSR_<computername> (or a custom anonymous account if you changed it), so giving the wrong account rights or only the file (not the folder) will still fail. (support.microsoft.com) (learn.microsoft.com)

Practical checklist (work through in order):

  • Confirm the anonymous account IIS is actually using (IIS Manager → site/virtual directory → Directory Security → Edit for Anonymous access). (support.microsoft.com)
  • Grant that account explicit Modify (read/write/create/delete) on the folder that contains the .mdb (not just the .mdb file). Jet creates an .ldb lock file in the same folder and needs create/delete rights there. (learn.microsoft.com)
  • Make sure the .mdb is not marked Read-Only and is not opened exclusively by someone. If an .ldb exists and nobody has the DB open, delete the stale .ldb. (learn.microsoft.com)
  • Avoid “Everyone = Full Control” as a permanent fix — give the web identity the minimum rights it needs (Modify) and keep tighter ACLs elsewhere. For recommended IIS account/right guidance see Microsoft’s NTFS/IIS guidance. (support.microsoft.com)

Quick test page (drop into the same web folder and browse it):

<%
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set f = fso.CreateTextFile(Server.MapPath("asp_write_test.txt"), True)
f.WriteLine("ok")
f.Close
Response.Write "wrote file"
%>

If this still gives 800A0046, the account performing the write still lacks NTFS rights — double-check the exact account name shown in IIS and the folder ACLs.

Notes tied to earlier replies: was right to think about the IUSR account, but the crucial point is folder-level Modify and which account is used; and pointed toward IIS/authentication checks — use the IIS steps above to confirm the account and permissions before changing ACLs system‑wide. (support.microsoft.com)

Recommended Answers

All 3 Replies

Member Avatar for achyut

May be this is a problem of your explorer so plase upgrade your explorer or change it and try to run the program also check that IIS is work properly or not

Member Avatar for VSBrown

I have a page of faq's for my ASP Application I built and it has answers to many common errors that occur in ASP pages and on Windows 2000 and Windows 2003 Server.

Read This : http://www.ezaspsite.com/ezfaq/index.asp#42

Hope it helps. :)

Member Avatar for dexterz

Right click the DB, hit properties. Under properties, hit tab security. In the security window, click add IUSR and click apply. Boom your done.

www.ex-designz.net
Dexter

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.