i recently just uploaded an access database only to find that it has read only persmission, so any adding, updating, deleting etc.. doesn't work anymore. the file became read only when i uploaded it. How do i change the read/write access to this file online?
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
Im just not sure how to go about it because im new to asp. I want to write an ASP script that will read a money amount from an SQL database and when money is taken through a payment it will change the value in the database.
I need to be able to find a record by a unique code from a ms access database,take the value of the price field in that record,then store the value in a JavaScript variable. These variables are being used for calculations.
So can I change the hard coded JavaScript code e.g. var price1=(229); // 229 being $229 the price for item1
to var price1=(item1); // item1 = 229 - value read from database and stored in variable price1.
Actually, I do not know why i can not add records to my access database table by using asp code, I get an error that tells me that the database file or object is read only file even though the file is not readable only from its proprties, I need some helpful information to solve this problem.
how to connect to a mdb database and read from it. But how can i make a simple textarea that takes inout and writes it.
all i want is a textarea with submit so i can write to my database only with a couple of words i dont have any code so fare apart from read the data and connect.
I have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt) DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
My database is working perfectly and I am still getting the following error:
Microsoft JET Database Engineerror '80040e09'
Cannot update. Database or object is read-only. /raven/aspBoardFunctions.asp, line 144
I called my new webspace provider and they said you should be able to change permissions with my ftp program. I looked and viewing permissions is the only thing I find. Any suggestions? Code:
I have an asp app that connects to an Access database. It works properly at my work on XP with IIS5.1 running.
I zipped up the asp pages and the Access database and emailed it to my home, which is XP and runs IIS5.1. When I recreate my work environmnet at home and try to update the database I get the following error when the code hits my AddNew method.
Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only.
I've tried going into Access/Security/Tools/User and Group Permissions and setting all the tables to be able to update. I've even created new ODBC drivers, but neither has worked. The database is not set to read-only.
I am trying to add a record to a database. I keep on getting the error message:
Error Type: Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /client_add_db.asp, line 31
Line 31 is rst.AddNew
I have checked the attributes in the folder - it is not set to read only. For some reason the folder that the DB is in will not let me make the folder NOT read only - I have even tried the attrib command as recommended by ms in the cmd but that will still not change the dir to not be read-only although that did make the db not read-only.
I was on here recently about error 500 messages (which I managed to sort by replacing the forum).However I am still getting error 500 messages with two sites. Both are trying to update information in the database. It displays info correctly, just doesn';t update. But everything is ok afaik and it works fine on my pws.
The errors are as follows (from different pages): error type 1 Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. error type 2 Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
I want to set up a simple database for my mom to enter her recipes into. I am going to use Access and ASP. In the database, I will have five fields (Recipe_ID, Recipe_Title, Recipe_Ingredients, Recipe_Instructions, and Recipe_Image). When my mom goes to enter a recipe, I want to ask the form to ask my mom how many Ingredients?
She will then specify "n" number of ingredients which will cause the page to display "n" number of text boxes. I can figure this part out myself. When the form is submitted, I want a script that will read and concatenate the ingredients, wrapping <li> tags around each one. The challenge for me is the reading of an undetermined number of form elements?
I,ve uploaded an MS Access DB to a web host and find that although I have set the DB permissions to Read and Write the actual tranfer changes these permissions and when I try to write to the DB there is an error to the effect that the DB is read only.
I have downloaded the DB I uploaded with full read/write permissions and find that the DB is read only.
when I retrieve data from the my database if I got the name and description. I want only display the first 20/30 letters of the description but I don't know how to do.
I have an ASP web site that I can read an XML file and process it fine. However, now I am asked to read XML data via (I think) a web service url. I looked at the ADO Stream and it looks like it may be a way to do this, but I'm not sure. I need to read 2 different streams, one with data and one with returned images.
I need to process the data like a recordset and load it (and other) information into a web page and return to the browser. Can anyone point me in a direction to read more about how to do this and/or some samples?
I need to use ASP to read a SQL db for dates. If the date falls within "this (current) month", I need to auto-populate a word document with the corresponding information from the tables... Is this possible.
I have an asp page currently such as default.asp?x=1&y=2&z=3
Now I want to keep the existing parameters and attach another parameter to it and resend to default.asp
As the original parameters are dynamic, and may or may not be generated, the only way is to read the current url and to simply add my new parameter such as h=5 to the url.
I don't know how to read the current url.
I tried Request.ServerVariables("SCRIPT_NAME") but that didn't include the parameters. i.e. it just returned the default.asp
I got a database with user and email in it. Now I want when a user logs into my page that it automaticly fills in the email into a email form. How can I do that in Asp.
how to modify this script to make the connection to the MS Access database read only, so that writing to the database directory is no more necessary (currently, I have to give IUSR write permissions so that the .LDB file can be created... but I don't need that because I want the database to be read only, and I don't want to grant write permission to IUSR).Code: ---- cst = "Provider=Microsoft.Jet.OLEDB.4.0;" &_ "Data Source=" & Server.MapPath("/database/riviste.mdb") set conn = CreateObject("ADODB.Connection") conn.Mode = 1 conn.open cst strSQL="SELECT * FROM riviste ORDER BY Titolo" set rs=conn.execute(strSQL) ----