Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 6th, 2004, 05:26 PM
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Read only Database error

Hi all ,
have a problem which seems to have been solved by member known as "theokrtz". When attempting to insert data into an Access database via an asp driven web page using forms, i keeping getting the message 'Cannot update. Database or object is read-only.'

As the application i'm working on is 80% dependent upon database insertion/extraction i need to get this problem sorted asap. Any solutions offered are greatly appreciated. Thanks for taking the time to read this plea for help,
larry101

Reply With Quote
  #2 (permalink)  
Old September 6th, 2004, 05:40 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Take a look at this thread that was handled a while before.
Cannot update. Database or object is read-only

You may have made a search on this site regarding this error. If you want you can also look at theokrtz's thread too. Here it is.
Update Problem under wwwroot folder

Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #3 (permalink)  
Old September 7th, 2004, 06:49 AM
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Happygv , thanks for quick reply.
I have looked at both threads. Neither help. Any other suggestions?
Also , without using 'cookies' , is there any other way to make a variable available to other pages in an application? For example, the users' username is required in several pages where database insertion and extraction are required.
Thanks to all for help given,
larry101.

Reply With Quote
  #4 (permalink)  
Old September 7th, 2004, 07:08 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,111
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Make sure the IUSR_machinename account has write permissions to the folder that the database in located.

Reply With Quote
  #5 (permalink)  
Old September 11th, 2004, 08:41 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Larry,
Quote:
quote:I have looked at both threads. Neither help. Any other suggestions?
There is no other work around for this. All that needed to fix that has been discussed in those threads. I am not sure why you still have problem with it. Giving Read/Write permission for IUSR_COMPUTERNAME (on the webserver-that run IIS) to the ACCESS MDB file atleast, or to the folder which contains MDB should solve that problem. Did that not help even after doing so?

Without cookies, there is a way of doing that, using HIDDEN FIELD, but you have to always post the data to the other pages, and request them in those pages. I dont think this is that easy to handle.

Use Session variables that are available to all pages, till the session expires/user closes the browser. This should be an easier solution.

Cheers!
_________________________
- Vijay G
Strive for Perfection
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database or object is read-only ryanb Access ASP 25 January 17th, 2014 06:36 PM
Cannot update. Database or object is read-only. zedekiah Classic ASP Databases 1 May 2nd, 2008 09:30 AM
permit read only while database is OPEN Belier Access 5 April 6th, 2004 08:26 PM
How to read/write Access Database jmmendes Access VBA 0 November 18th, 2003 01:26 PM
DLL generates Database read-only error Howard Classic ASP Databases 0 July 19th, 2003 08:18 AM



All times are GMT -4. The time now is 03:00 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.