Hi, There:
I am working on a commercial ASP web application which use MS Access 2000 as
database.
When configuring the database access, I got an error saying that this
database is a read-only database. I checked the database property, it shows
that this database is archive, not read only (The database property is found
by:open database and then File -> Database properties -> on the General tag.
there is no way to change these property, as these boxes are gray, not
enabled.). I can directly make change on the database using Access, so, my
guess is the problem is not really database related, am I right?
According to the instruction of the software, the database folder must have
read and write permissions given to the "anonymous web user account", I have
set the database folder to share and gave all permissions to "anonymous
logon " and "every one", but the problem is still there. I am just
wondering, what is the "anonymous web user account" in Windows 2000 server
and IIS?
Anyone can help?
CM 5 5065
"CM" <cm***@hotmail. com> wrote in message
news:eq******** ******@TK2MSFTN GP10.phx.gbl... Hi, There: I am working on a commercial ASP web application which use MS Access 2000
as database.
When configuring the database access, I got an error saying that this database is a read-only database. I checked the database property, it
shows that this database is archive, not read only (The database property is
found by:open database and then File -> Database properties -> on the General
tag. there is no way to change these property, as these boxes are gray, not enabled.). I can directly make change on the database using Access, so, my guess is the problem is not really database related, am I right?
According to the instruction of the software, the database folder must
have read and write permissions given to the "anonymous web user account", I
have set the database folder to share and gave all permissions to "anonymous logon " and "every one", but the problem is still there. I am just wondering, what is the "anonymous web user account" in Windows 2000 server and IIS?
The account is named IUSR_yourserver name. See here to learn how IIS uses
the IUSR account for anonymous access: http://support.microsoft.com/?kbid=264921
Also, the problem is not with "share" permissions, but rather NTFS
permissions. http://www.aspfaq.com/database.asp http://www.aspfaq.com/show.asp?id=2009
--
Tom Kaminski IIS MVP http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS http://mvp.support.microsoft.com/ http://www.microsoft.com/windowsserv...y/centers/iis/
"CM" <cm***@hotmail. com> wrote in message
news:OC******** ******@TK2MSFTN GP10.phx.gbl... Thanks for your reply. It really contains very useful information.
However, I am not familiar with windows administration, could you please tell
me how to grant "Log On Locally" permissions to IUSR_yourserver name? In the property of IUSR_yourserver name, I cannot find "Log on locally".
Where is the permission located?
You don't need to do that. It works fine right "out of the box" with
Access if you simply grant the account read/write permissions to the
file and folder it is in.
The less things you change the better off you are, *especially* if you
are not familiar with Windows administration.
--
Phillip Windell [CCNA, MVP, MCP]
WAND-TV (ABC Affiliate) www.wandtv.com
"CM" <cm***@hotmail. com> wrote in message
news:OC******** ******@TK2MSFTN GP10.phx.gbl... Hi, Tom:
Thanks for your reply. It really contains very useful information.
However, I am not familiar with windows administration, could you please tell me
how to grant "Log On Locally" permissions to IUSR_yourserver name? In the property of IUSR_yourserver name, I cannot find "Log on locally". Where is the permission located?
The account will have that permission by default. To manually assign the
"Log on Locally" right, open Administrative Tools and select Local Security
Policy. In Security settings, expand Local Policies and User Right
Assignment. Click Log on locally, and then click Add.
--
Tom Kaminski IIS MVP http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS http://mvp.support.microsoft.com/ http://www.microsoft.com/windowsserv...y/centers/iis/
Thanks a lot!
The strange thing is, I give even admin's permission to the
IUSR_yourserver name, but it still not working. However, after I checked and
debugged the offence asp page (actually, I didn't change any thing), the
error disappeared, even after I tool away the admin permission.
Anywhere, you did give me a lot of useful experience and knowledge. Thank
you!
CM
"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bp******** *@kcweb01.netne ws.att.com... "CM" <cm***@hotmail. com> wrote in message news:OC******** ******@TK2MSFTN GP10.phx.gbl... Hi, Tom:
Thanks for your reply. It really contains very useful information. However, I am not familiar with windows administration, could you please tell me how to grant "Log On Locally" permissions to IUSR_yourserver name? In the property of IUSR_yourserver name, I cannot find "Log on locally". Where
is the permission located?
The account will have that permission by default. To manually assign the "Log on Locally" right, open Administrative Tools and select Local
Security Policy. In Security settings, expand Local Policies and User Right Assignment. Click Log on locally, and then click Add.
-- Tom Kaminski IIS MVP http://www.iistoolshed.com/ - tools, scripts, and utilities for running
IIS http://mvp.support.microsoft.com/ http://www.microsoft.com/windowsserv...y/centers/iis/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Gerry |
last post by:
I have a developer here with a website running with only "Windows
Integrated Authentication" set on a Windows 2000 member server that
uses GetObject to get a user's group membership in the domain. This is
the code she's using:
set adsUser = getobject("WinNT://" & strUsername)
for each group in adsUser.groups
GrpList = GrpList & lcase(trim(group.name)) & ";"
next
|
by: Tom Wild |
last post by:
Hi
I am trying to create a webform that connects to an Access database.
If I use the connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Gizmo\Gizmo.mdb"
Then the application connects to the database and downloads data fine but
when I try to fire an Update command I get the following error:
"Problem firing System.Data.OleDb.OleDbCommand - Operation must use an
updateable query"
|
by: Guadala Harry |
last post by:
Is there any way for one Session to remove and update objects in another
Session? I seriously doubt it, but thought I'd ask. Here's why: I have some
data that is unique per user (or per session - similar to "welcome back,
Jim" after Jim logs in) and consumed across multiple pages. This "per user"
data lives in a database, so toward improving runtime performance I want to
cache data supporting this and similar per user features. Because the...
|
by: damontimm |
last post by:
My setup: Mac OS 10.4.4; mysql 4.x ... everything was installed and
working fine for some time. Today, I added drupal to my system and had
to create a new database in mysql -- now I am having some problems. I
will outline the problem, what I have tried to do to fix it, and what I
think caused it. Hope you can help and I am sorry this is long.
The problem: I can't login to mysql anymore with the "root" username
(which is where I have all...
|
by: kanu |
last post by:
Hi,
We have moved our domain controllers from win2K to win3K.
The script below doesnt work at all now because by default Win3K disables "Network access: Let Everyone permissions apply to anonymous users"
GetObject("WinNT://domain/domainController/username,user")
We are using GetObject to get the user groups, so as to restrict them to certain parts of the website.
It still works with one of the old DC's which is win2K.
| |
by: FrankieBakerJr |
last post by:
Hello all
I have an ASP.NET 2003 application (running Windows XP) that allows user to change and reset their Active Directory password. I'm using an admin account to query and reset the passwords once the user enters criteria to identify themselves. I want to check, in code, the Account Option "User cannot change password" in Active Directory to determine if they can or cannot change their password but I don't know how to do that.
Any help...
|
by: WP |
last post by:
Hello, I need to communicate with a db2 database from a java program
and this java program needs to check which "user tables" there are. I
came up with the following query which I tried in Control Center:
select tabname, tabschema from syscat.tables where tabschema !=
'SYSCAT' and tabschema != 'SYSIBM' and tabschema != 'SYSIBMADM' and
tabschema != 'SYSSTAT' and tabschema != 'SYSTOOLS';
It seems to work, it returns just the tables that I...
|
by: Peter |
last post by:
Hi
I've been delving into "delegates" and "anonymous methods", and now
I've come across the term "closure".
Some information I've found says that C# does not have closures, other
information says that C# does have closures.
My problem is I can't quite grasp what "closures" are. The examples I
have seen seem to be "anonymous methods". What is the subtle difference
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |