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 4th, 2004, 10:58 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 105
Thanks: 0
Thanked 0 Times in 0 Posts
Default Prob with "Updateable SQL query"

Hi there...

I`m using Windows XP Pro with IIS 5.1
My db is on Access. I`ve checked that the .mdb file is not a read-only file.
I don`t know what else to do...? Please help me. The excact code was working fine on Windows 2000 but now on Windows XP I`m having probz when I`m trying to insert, update or delete something from the db. :(

Does anyone knows the solution???

The permision from IIS are ok. (I`ve checked the "read" & "write").

 
Old December 4th, 2004, 01:19 PM
Authorized User
 
Join Date: Nov 2004
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey,

I was having the same problem. Do one thing try to open your open your database in WinXP ..if access files open it means your MS Office working fine...otherwise you have to d/l a service pack for it from microsoft website...

Else let us know what error comes when you try to update?

Farzan Q.
BS(TeleCommunication)
Iqra University.
 
Old December 4th, 2004, 01:22 PM
Authorized User
 
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The Jet Driver needs not only Read&Write to the file but also the directory containing the file. This because it needs to create the locking file. If it does not have this it creates the locking file in a temporary directory but then opens the database as read-only since the locking file is now not available to all instances of the Jet Driver.

I hope this helps.

 
Old December 5th, 2004, 06:29 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 105
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do you know how is this service pack called???

I`ve tried to disable the "read-only" box from the folder that contains the db. But as soon as I close the properties window of that folder then in some strange way the system makes that box (the "read-only" box on the properties) to seem like it`s read-only (the box in the properties is not checked but it`s something like "blur"). Do you understand what I mean? I don`t know which could be the problem... :( I hope that I`ll find a service pack that will solve that problem.

Are you guyz working on Windows XP with Access db???

 
Old December 5th, 2004, 07:12 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

Did you disable 'Simple filesharing (recommended)' ? Otherwise go ahead and do so...

Open up Explorer.
Go to Options->View
Clear the checkmark...

 
Old December 5th, 2004, 07:31 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 105
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for your replies...

the solution lies here:
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?????
 
Old December 5th, 2004, 11:21 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

You should take a look at this: http://www.4guysfromrolla.com/ASPScr....asp?FAQID=166






Similar Threads
Thread Thread Starter Forum Replies Last Post
When is a query updateable? donevco Access 2 January 31st, 2007 11:56 AM
updateable query dilionyi Visual Basic 2005 Basics 7 August 16th, 2006 11:42 AM
help me ! can't updateable query ! 123123 Classic ASP Databases 1 April 18th, 2005 08:54 AM
Checking null values in Query(SQL Server) Prob leo_vinay Classic ASP Databases 2 December 28th, 2004 04:31 AM
You must use an updateable query faisar ASP.NET 1.0 and 1.1 Basics 3 July 2nd, 2004 06:59 AM





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