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-25 : 18:05:52
|
| 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. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-25 : 18:11:40
|
| Have you checked to see the access database file is read-only?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
BansheeTwin350
Starting Member
4 Posts |
Posted - 2004-05-25 : 23:58:51
|
| If you mean by right clicking on the file and selecting properties, then yes I have checked to make sure it is not read only. Thanks. |
|
|
|
|
|
|
Getting Read/Write Access to Database?