Wrox Programmer Forums
|
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 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 December 20th, 2004, 05:12 PM
Authorized User
 
Join Date: Nov 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default weird problem! Please Help

Hi,
 I have an ASP page which acces to an ACCESS database
It was working perfectly since I change a little bit my database,
I only add new fields and create some new joins between new tables tables. Now when I want to do change to the database from my asp page it tell:
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only

But my connection is NOT readonly it is :
objRS.Open "BoardTable", strConnect, adOpenStatic, adLockOptimistic, adCmdTable


I did'nt change anything to my asp page, only new tables and joins in my database and the fields that I use in my ASP page haven't change to.

Please help me, it was working perfectly and now I don't understand anything

Thanks a lot

Johnjohn

 
Old December 20th, 2004, 06:28 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax
Default

Let's say the name of your db is "your_db.mdb" - then look for a file called "your_db.ldb" in the same folder - if it's there, delete it! It's a lock on the db.

 
Old December 20th, 2004, 06:37 PM
Authorized User
 
Join Date: Nov 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you but I know that and check it and it's ok...

 
Old December 20th, 2004, 06:59 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax
Default

Ok...
Assuming fileperms are ok too: Try running your INSERT/UPDATE-statement from within Access. Ie. Copy/Paste it into the SQL-window of a new view. See if Access gives you some error - it's probably a question of referential integrity...

 
Old December 21st, 2004, 05:24 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 184
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Jonax
Default

Is this resolved?

 
Old December 21st, 2004, 10:27 AM
Authorized User
 
Join Date: Nov 2004
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, it was a security issue but I really don't know how come it change by itself but anyway it's working now thanks Jonax






Similar Threads
Thread Thread Starter Forum Replies Last Post
Very WEIRD Mail Problem Lee Dumond BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 January 16th, 2008 02:11 PM
weird problem with Ch 9 example proslambano BOOK: Ivor Horton's Beginning Visual C++ 2005 1 February 2nd, 2007 02:06 AM
Weird Access Problem MattyJ Access 2 October 1st, 2004 02:10 PM
weird Oracle problem! pankaj_daga Oracle 2 July 12th, 2004 09:33 PM





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