data access

[hugh welford]

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.as p, 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

[Ray Costanzo [MVP]]

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**********@b tinternet.com> wrote in message
news:e6******** ******@tk2msftn gp13.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.as p, 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

[Curt_C [MVP]]

folder level permissions perhaps?

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"hugh welford" <hu**********@b tinternet.com> wrote in message
news:e6******** ******@tk2msftn gp13.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.as p, 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

[Hugh Welford]

thanks guys

Hugh
"hugh welford" <hu**********@b tinternet.com> wrote in message
news:e6******** ******@tk2msftn gp13.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.as p, 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

[Bob Barrows [MVP]]

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_<machinena me> 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.as p, 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"

[joker]

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.as p, 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