Setting Permissions to Access Database - step by step guide
Discuss Setting Permissions to Access Database - step by step guide in the ASP Development forum on ASP Free. Setting Permissions to Access Database - step by step guide ASP Development forum discussing ASP related topics including coding practices, ASP tips, and more. Active Server Pages (ASP) enables you to empower your HTML pages dynamically with robust scripting options.
We cover the world of technology
like no one else, constantly updating you with the best information
available on open source software, Microsoft technologies, hardware
and news from around the world.
Posts: 28,838
Time spent in forums: 3 Months 2 Weeks 1 Day 14 h 30 m 10 sec
Reputation Power: 2389
Setting Permissions to Access Database - step by step guide
The following will solve those two common errors:
---
Operation must use an updateable query
cannot update database database is readonly
---
Such errors occur when you try to update/delete/insert records
to Access Database, but don't have proper permissions. Note, this is not IIS problem but rather Windows problem.
Follow those steps, according to the Server OS: Window 2000 Professional/Windows 2000 Server
Browse to the database file meaning the .MDB file by double
clicking My Computer and browsing to the file.
Right click the file.
Choose Properties
Go to the Security Tab
Click the Add button
Select IUSR_[computer name] and click Add
Click OK
Check the checkbox for Write permission in the Allow column
Confirm.
Window XP/Windows 2003 Server
Browse to the database file meaning the .MDB file by double
clicking My Computer and browsing to the file.
Windows XP users:
Go to Tools --> Folder Options
Go to View tab
Uncheck "Use simple file sharing" and confirm.
Right click the file.
Choose Properties
Go to the Security Tab (XP users - if it won't show make sure
you followed instructions in step #2)
Click the Add button
Type IUSR_[machine name] in the box, replace "machine name"
with the name of the computer as you can see in the
"From this location" textbox
Click OK, check the checkbox for Write permission in Allow column.
Confirm.
That's all, you may have to repeat above steps to the folder
containing the mdb file as well.
Posts: 28,838
Time spent in forums: 3 Months 2 Weeks 1 Day 14 h 30 m 10 sec
Reputation Power: 2389
Quote:
Originally Posted by Phoenix_riser
Just set up new XP Pro - added IIS but no security tab! How do I add this.
Thank you in advance
the Security tab has nothing to do with IIS..
read the section "Window XP/Windows 2003 Server" and see step #2.
it explain what you have to change in the Folder Options.
How to Present Effectively Online This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
Open Source Security Myths Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual
property restrictions (or arrangement such as the public domain), and is
usually developed with the input of many contributors.
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
Understanding Web Application Security Challenges This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
ASP Free Forums Sponsor:
January 25th, 2006, 09:29 AM
Setting Permissions to Access Database - step by step guide
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Highly recommended
Linear Mode
