can't update and addnew data, help plz

milk_vanilla · December 1st, 2004, 08:26 PM

hey there, i'm newbie here =)
hey i what would like to know, is there anybody know resolution for my problem

i'm using access for the database, then i write my own asp codes for updating or make a new data for the table.
but when i run into it, it seems has an error

it says, " error.....the object or database is read only"
but i'm sure that my code has right code, coz i just write down the codes from wrox book.

thx with u guys companion
bye

rajanikrishna · December 1st, 2004, 08:55 PM

Hi,

Check the virtual folder permissions.

-------------
Rajani

abelconde · December 2nd, 2004, 11:17 AM

Check virtual folder permission in
Internet Information Server!

ChrisScott · December 2nd, 2004, 12:27 PM

What are the security permissions on the .mdb file - can IUSR_[yourmachinename] (or everyone etc.) read/write from/to the file?

Cheers,

Chris

milk_vanilla · December 2nd, 2004, 12:46 PM

hey, i uncheck it with right on it's directory,select property, and then uncheck the "read-only" button isnt it?>
but it still check it, even i already uncheck it.
-_-;
am i wrong?

doosti · December 2nd, 2004, 04:21 PM

Quote:

quote:Originally posted by milk_vanilla
hey, i uncheck it with right on it's directory,select property, and then uncheck the "read-only" button isnt it?>
but it still check it, even i already uncheck it.
-_-;
am i wrong?

Hey,

Right click on .mdb file and then select properties and then uncheck the checkbox of readonly.
Secondly, have u typed

rst.open sql,conn,3,3

???

3,3, allows database to be updated or deleting...and it pointer points forward...i m not sure about the details of this 3,3 but it sure helps!

Cheers!

Farzan Q.
BS(TeleCommunication)
Iqra University.

milk_vanilla · December 2nd, 2004, 08:22 PM

i already uncheck the checkbox read only, but something weird came out , when i right clicked on the forlder for my db files, it checked again automaticly, with like a "blur" check, seems it cannot changed
it says
"Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only."
anybody can help with my problem? i have to solve this problem, my assignment due came soon...
cheers!

doosti · December 3rd, 2004, 03:45 AM

Try to copy the database in any other partition and then check its attributes by right clicking on the file.

Or make other db.

One thing more try to show all files in ur PC. and then check if your db file has any previous opened file copy??? if you found delete it.

Farzan Q.
BS(TeleCommunication)
Iqra University.

Varg_88 · December 5th, 2004, 07:35 AM

------------------------------------------
this reply is posted also on another topic
------------------------------------------

I had a problem like yours on my application. So...

the solution lies here (I guess):
http://support.microsoft.com/default...b;en-us;175168

The only thing I had to do was to:
1. go to the properties of the folder that contains my db
2. go the the WEB SHARING tab
3. click on "Share this folder"
4. check "read, write, *script source*"
5. and so it is done.

I`m working on Win XP pro with IIS 5.1 (SP 1), MS Access db.

But now I have the following question... is there a possibility to occur a security problem now that I`ve checked that "web sharing" function... or it`s just works fine like that?????