473,545 Members | 757 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.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

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

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**********@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

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

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_<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"
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.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


Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
5462
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 problem that I am facing is in dealing with (privacy) critical information like credit-card #s and SSNs or business critical information like sales...
6
5732
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 modified that is to upgrade a big, more than 100,000 lines DOS based program developed by FoxPro 2.x to .NET platform. The design is as previous and...
0
5369
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 Application Block (DAAB) in our .Net projects. We use SqlHelper in SQL based projects, and OracleHelper in Oracle based ones. OracleHelper was not...
32
3194
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 lost when they move to a new record. This seems to be the case when there are multiple users. When there is a single user using it, we don't seem to...
1
9183
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 will work for 9i and even 10g ) No one had what I needed, so I wrote it myself. I Rule. This code isn't going for efficiency, and isn't trying...
9
3286
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 >people moving from power user to developer, but now I suggest you browse >it, >too. It strongly emphasizes ADO, which knowledgeable Microsoft...
3
3481
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 site that has this prohibition, and I have uploaded DAPs to various sites and used them from those sites. I do not understand why any site...
1
2568
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 looking for a robust solution for a major application. Almost every developer seems to come up with a completely different solution. While many of them...
0
14394
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 be greater than 255 characters. 2. I have an access database. I link (not import) to the contents of the excel spreadsheet. In the design view in...
0
7456
marktang
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...
0
7390
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7649
Oralloy
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. ...
0
5960
agi2029
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...
0
3442
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3437
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1869
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1010
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
692
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.