Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BansheeTwin350
Starting Member
4 Posts |
 Posted - 2004-05-24 : 20:52:20
|
| 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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-24 : 22:03:34
|
| You need to request access from your ISP. They should provided db_owner on your database.Tara |
 |
|
|
BansheeTwin350
Starting Member
4 Posts |
Posted - 2004-05-25 : 15:14:31
|
| I contacted my ISP and they said I already have the permission to write to the database under the 'owner' account. Do I need to request that they change the permission of the 'Group' and 'Other' permissions to write also or are they doing something wrong? Also what do you mean by "They should provided db_owner on your database" Does that mean they have to edit the properties of my database and let it know who the owner is? Thanks very much!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-25 : 15:52:15
|
| I just reread your initial post and noticed you are using Access as your dbms. This is a SQL Server forum, so I provided a SQL Server answer. You'll want to post your Access question here:http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3Tara |
|
|
|
|
|
|
Getting Read/Write Access to Database?