469,327 Members | 1,211 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,327 developers. It's quick & easy.

data access

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

Jul 19 '05 #1
5 1650
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

Jul 19 '05 #2
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

Jul 19 '05 #3
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

Jul 19 '05 #4
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"
Jul 19 '05 #5
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


Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

32 posts views Thread by Neil Ginsberg | last post: by
1 post views Thread by Andrew Arace | last post: by
9 posts views Thread by Tony Lee | last post: by
3 posts views Thread by Lyle Fairfield | last post: by
reply views Thread by Purva khokhar | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.