Click to See Complete Forum and Search --> : Getting Read/Write Access to Database?
BansheeTwin350
May 24th, 2004, 09:05 PM
I am using asp and trying to add items to a database. When I only display the contents of the database, everything works wonderfully. But when I try to add a record, I get an error stating that the database or object is read only. I have set the lock and cursor type in my connection string and someone elsewhere told me that I may not have rights to edit the database. My question is, Is it possible that I don't have rights to edit the database even though I have access to place the database on my ISP's web server, and if so, how do I get access? Thanks for any help. I am using an Access database and asp with vbscript.
hspc
May 25th, 2004, 04:47 AM
contact the support and ask them to allow write permissions on the folder that contains the database file.
BansheeTwin350
May 25th, 2004, 11:43 AM
Does the owner permission the only one that has to have the write access, or does the 'Group' and 'Other' Accounts have to also have write access, because I spoke with my ISP and they said I already have the access to write. So I opened up WS_FTP and right clicked on the folder containing the database and chose 'chmod(UNIX)' and it shows a read access for all three groups, but only a write access for the owner group. Just wondering if I need to make the other 2 groups to have write permissions. Thanks for the reply!
hspc
May 25th, 2004, 03:36 PM
does chmod work on windows ?
it doesn't as far as i know.
this should be configured from IIS virtual folder not FTP.
BansheeTwin350
May 25th, 2004, 05:44 PM
I know the host has to be using UNIX for the chmod to change the permissions, but will it still show the current permissions when I open up chmod? And I have a feeling my ISP does not know how to configure this, so you are talking about the IIS virtual folder on their webserver because my ISP told me that I have write access to everything under my folder on the webserver. I think my ISP means that I can add remove files in my folder and they don't have the understanding of editing files. Thanks for the help!
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.