Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. 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 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 17th, 2006, 08:29 PM
Registered User
 
Join Date: Mar 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Microsoft JET Database Engine (0x80040E09)

I am running XP Professional.
Whenever I try and execute an
ADODB ADDNew() I get the following error message:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.

I have already made sure that the security on the Database is set to
Everyone yet I still get this error message, any suggestion on how I
might correct his problem?



 
Old July 18th, 2006, 10:49 AM
Authorized User
 
Join Date: Feb 2006
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Steweb




Visit my web site !
www.steweb.net
 
Old July 18th, 2006, 05:53 PM
Registered User
 
Join Date: Mar 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
Thanks for your reply. Can you tell me how can i check if the IUSR_machinename account has write permissions to the folder that the database in located?

Regards,
Lana

 
Old July 19th, 2006, 08:30 AM
Authorized User
 
Join Date: Feb 2006
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

...Look that link !

http://imar.spaanjaars.com/QuickDocID.aspx?QUICKDOC=287

Steweb




Visit my web site !
www.steweb.net
 
Old July 19th, 2006, 11:46 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I was just going to suggest that... ;)

Although it may be even better to look at this FAQ: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=263 as it also explains the reason for the error, and a step by step explanation of setting the correct permissions.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
 
Old July 19th, 2006, 05:44 PM
Registered User
 
Join Date: Mar 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
I was searched the Web last night and found very helpful side for this topic:
http://imar.spaanjaars.com/QuickDocID.aspx?QUICKDOC=263
It worked.


Thanks for your help

Cheers,

Lana

 
Old July 19th, 2006, 05:55 PM
Registered User
 
Join Date: Mar 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Imar,
This is exactly the page I found on a WEB.

Regards,
Lana

 
Old July 20th, 2006, 01:17 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Good. That means that search engines can find my site as well.... ;)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Blind by Placebo (Track 8 from the album: Meds) What's This?
 
Old April 2nd, 2007, 12:08 PM
Authorized User
 
Join Date: Aug 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to alirezaaali
Default

may be problem is in opening record set
i have this problem to
my record set line is :
objRS.open "Select * from tblusers",objConn,,3,0

but is dose not work !!!!!!!

 
Old April 2nd, 2007, 12:24 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Can you define "does not work"? Do you get an error? If so, what is it? And how does the rest of the code look like?

Did you follow the suggestions from the articles linked to in this thread?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft JET Database Database Engine (0x80040E09 cannielynn0312 Classic ASP Professional 2 December 17th, 2007 02:50 AM
NEW: Microsoft JET Database Engine error'80040e14' rishinicolai Classic ASP Databases 4 December 13th, 2005 05:58 AM
Microsoft JET Database Engine (0x80004005) kenh BOOK: Beginning ASP 3.0 4 April 6th, 2005 08:52 AM
Microsoft JET Database Engine (0x80040E14) tks_muthu Classic ASP Databases 5 January 1st, 2005 10:17 PM
Microsoft JET Database Engine (0x80040E14) HaverkPJ Classic ASP Databases 2 November 16th, 2004 11:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.