Need the permission to update database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm trying to add new/update my Access database using Vbscript (in ASP
application). However, i'm not able to do so. I'm getting this message:

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/test/Script/LoadToDatabase.asp, line 36

I dont think the my VBscript is wrong, as i'm able to query my Access
database to display the contents on it on my webpage. I believe has to do
with some permission thing since i'm using the internet to update/add new to
my Access database.

I dont see any problem when i manually open the Access database and
update/add new (click open the Access file on my C: drive).

Please advise.

PS: I'm using Access 2003.
 
You need to give the anonymous user the web server runs under (usually
IUSR_computername) rights to the folder where the .mdb resides and to the
..mdb file itself. IUSR_computername only has Read rights by default, which
is fine for displaying data but to update data it needs Write and Create
(for the record-locking [.ldb] file) rights.
 
While I don't know all of your specifics, a common source of this type of
error is when the ASP application does not have write permissions to the
directory in which the database is located. Apparently, the ASP application
has read permissions as you can query the database for information. I would
suggest right-clicking on the database folder, selecting Properties and then
checking the Security tab. Make sure the ASP application has write
permissions on the folder.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi,
I'm trying to add new/update my Access database using Vbscript (in ASP
application). However, i'm not able to do so. I'm getting this message:

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/test/Script/LoadToDatabase.asp, line 36

I dont think the my VBscript is wrong, as i'm able to query my Access
database to display the contents on it on my webpage. I believe has to do
with some permission thing since i'm using the internet to update/add new to
my Access database.

I dont see any problem when i manually open the Access database and
update/add new (click open the Access file on my C: drive).

Please advise.

PS: I'm using Access 2003.
 
Back
Top