Hi using XP Pro with IIS5 installed on my machine for offline development.
I have a DSN set up which points to an ACCESS database saved outside the web
in c: drive directory using no system database. The database itself has full
read/write priviledges.
The .asp page reads the data table, but on update I get " Microsoft OLE DB
Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
/dating/www/registerconf.asp, line 127 "
When I go to the database directory in Windows Explorer and right click for
properties, it tells me that the directory attributes are read only (green
square in the check box). So, I uncheck the box and save, and it asks me to
confirm that I want to un-set the read-only attibute, but the attribute does
not change, and the green bax is back when I look again.
Confused to say the least.
Any help from anyone?
Thanks in adbvance, Hugh 5 1989
1. XP Pro has IIS 5.1, not 5, just to be nit-picky
2. Instead of a DSN that uses old ODBC technology, consider switching to
OLEDB. You can get your OLEDB connection string at www.connectionstrings.com. (Look at Access\OLE DB, OleDbConnection area.)
3. Your IUSR account needs to have read/write/modify NTFS permissions to
the ~directory~ housing the .mdb file, and make sure that your .mdb file is
set to inherit permissions from its parent (the directory that it's in.)
Also see http://www.aspfaq.com/show.asp?id=2009
Ray at work
"hugh welford" <hu**********@btinternet.com> wrote in message
news:e6**************@tk2msftngp13.phx.gbl... Hi using XP Pro with IIS5 installed on my machine for offline development.
I have a DSN set up which points to an ACCESS database saved outside the web in c: drive directory using no system database. The database itself has full read/write priviledges.
The .asp page reads the data table, but on update I get " Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. /dating/www/registerconf.asp, line 127 "
When I go to the database directory in Windows Explorer and right click for properties, it tells me that the directory attributes are read only (green square in the check box). So, I uncheck the box and save, and it asks me to confirm that I want to un-set the read-only attibute, but the attribute does not change, and the green bax is back when I look again.
Confused to say the least.
Any help from anyone?
Thanks in adbvance, Hugh
folder level permissions perhaps?
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"hugh welford" <hu**********@btinternet.com> wrote in message
news:e6**************@tk2msftngp13.phx.gbl... Hi using XP Pro with IIS5 installed on my machine for offline development.
I have a DSN set up which points to an ACCESS database saved outside the web in c: drive directory using no system database. The database itself has full read/write priviledges.
The .asp page reads the data table, but on update I get " Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. /dating/www/registerconf.asp, line 127 "
When I go to the database directory in Windows Explorer and right click for properties, it tells me that the directory attributes are read only (green square in the check box). So, I uncheck the box and save, and it asks me to confirm that I want to un-set the read-only attibute, but the attribute does not change, and the green bax is back when I look again.
Confused to say the least.
Any help from anyone?
Thanks in adbvance, Hugh
thanks guys
Hugh
"hugh welford" <hu**********@btinternet.com> wrote in message
news:e6**************@tk2msftngp13.phx.gbl... Hi using XP Pro with IIS5 installed on my machine for offline development.
I have a DSN set up which points to an ACCESS database saved outside the
web in c: drive directory using no system database. The database itself has
full read/write priviledges.
The .asp page reads the data table, but on update I get " Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object is read-only. /dating/www/registerconf.asp, line 127 "
When I go to the database directory in Windows Explorer and right click
for properties, it tells me that the directory attributes are read only (green square in the check box). So, I uncheck the box and save, and it asks me
to confirm that I want to un-set the read-only attibute, but the attribute
does not change, and the green bax is back when I look again.
Confused to say the least.
Any help from anyone?
Thanks in adbvance, Hugh
Your answer will be found in this article: http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors
Read the article, but the short answer is:
Assign read/write filesystem permissions for the folder containing your
database to the IUSR_<machinename> account (aka Internet Guest Account).
Another recommendation, which won't help with this particular issue but
should be followed, is to not use a DSN. ODBC is deprecated technology which
does not supply the functionality and robustness supplied by the native Jet
OLEDB provider. See www.connectionstrings.com for examples of connection
strings using the Jet OLEDB provider.
Bob Barrows
Oh wait! More below
Hugh Welford wrote: Hi using XP Pro with IIS5 installed on my machine for offline development.
I have a DSN set up which points to an ACCESS database saved outside the web in c: drive directory using no system database. The database itself has full read/write priviledges.
The .asp page reads the data table, but on update I get " Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. /dating/www/registerconf.asp, line 127 "
When I go to the database directory in Windows Explorer and right click for properties, it tells me that the directory attributes are read only (green square in the check box). So, I uncheck the box and save, and it asks me to confirm that I want to un-set the read-only attibute, but the attribute does not change, and the green bax is back when I look again.
I missed this part! Are you an administrator on that box? If so, and you
still can't clear the read-only attribute, I have no clue what you need to
do.
Bob Barrows
--
Microsoft 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"
I'd suggest the following pages for you database connection. http://msdn.microsoft.com/library/de...components.asp http://www.aspfaq.com/show.asp?id=2126
hugh welford wrote: Hi using XP Pro with IIS5 installed on my machine for offline development.
I have a DSN set up which points to an ACCESS database saved outside the web in c: drive directory using no system database. The database itself has full read/write priviledges.
The .asp page reads the data table, but on update I get " Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. /dating/www/registerconf.asp, line 127 "
When I go to the database directory in Windows Explorer and right click for properties, it tells me that the directory attributes are read only (green square in the check box). So, I uncheck the box and save, and it asks me to confirm that I want to un-set the read-only attibute, but the attribute does not change, and the green bax is back when I look again.
Confused to say the least.
Any help from anyone?
Thanks in adbvance, Hugh This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: sffan |
last post by:
I am new to database programming and was curious how others solve the
problem of storing encrypted in data in db table columns and then
subsequently searching for these records.
The particular...
|
by: Hamed |
last post by:
Hello
I have employed as a developer in a software company that its team uses
FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to
migrate to VS.NET. There is a project...
|
by: sedefo |
last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i
was researching how i can write a database independent data access layer. In
my company we already use Data Access...
|
by: Neil Ginsberg |
last post by:
We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and users
are complaining that unsaved data is being...
|
by: Andrew Arace |
last post by:
I scoured the groups for some hands on code to perform the menial task
of exporting table data from an Access 2000 database to Oracle
database (in this case, it was oracle 8i but i'm assuming this...
|
by: Tony Lee |
last post by:
Some time a ago, on this newsgroup the following comments were made in
recommending
good references for Access (2003)
>I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
|
by: Lyle Fairfield |
last post by:
In a recent thread there has been discussion about Data Access Pages. It
has been suggested that they are not permitted on many or most secure sites.
Perhaps, that it is so, although I know of no...
|
by: Johann Blake |
last post by:
I am looking for a good solution on how to implement data access in an
application so that there is a clean separation between the data access
layer, the business layer and the GUI layer. I am...
|
by: Grip |
last post by:
Hi,
I have gone throught the group and Microsoft's online help and have
seen many suggestions but I am still seeking clarity:
1. I have an excel spreadsheet. Column A contains text that may...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |