Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
|
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP 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 September 8th, 2003, 04:53 PM
Registered User
 
Join Date: Sep 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Unable to update database on server

Hi All,

I have a DSNless connection setup for an MSAccess database. I have tested the code on the local host, and it works perfectly fine. I'm able to update the database. But when after moving the files to the Server and when I try to update the database through the webpage, I get the following error.

ASPCode:
ASPDescription:
Category:Microsoft JET Database Engine
Column:-1
Description:Cannot update. Database or object is read-only.
File:/cai/dbase/drmartin/writetodb.asp
Line:12
Time:4:31:21 PM
Date:9/8/2003
Browser:Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
URL:/cai/dbase/drmartin/writetodb.asp
Query:

What kind of permissions do I need to set for the database and how do I set it. I understand that the database should have a write permission, but is it necessary for the owner, group and others to have the write permission ?

My server doesnt support chmod so how do i go about changing the permissions ?

Thanks

Senthil

 
Old September 23rd, 2003, 11:43 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

You didn't show your code. Does this help?

rs.open sql, conn, 3, 3

NOTE: 3, 3 is write mode for Access I think.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Update unable to find TableMapping ahager C# 5 June 23rd, 2007 06:20 AM
unable to update MySQL database with ASP don baroo Classic ASP Databases 7 November 22nd, 2004 01:22 PM
Unable to Update phungleon Access ASP 5 March 18th, 2004 05:23 AM
Unable to update database on server senthilpr_in Classic ASP Databases 0 September 8th, 2003 04:32 PM
[000] Unable to connect to server 'SERVER\SQL'; SQ ctanchan SQL Server 2000 1 August 15th, 2003 07:18 AM





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