Database Read Only Error

[lucidity23]

I am hitting a problem that I do not know if it is server based or if it is just my Access Database.

The asp pages read from the database fine. When you fill out any form on my site that updates a record in the DB, you get a read only error. now, the ASP has been working fine for many months. The only thing I have changed has been the database. I converted it from an Access 98 to an Access2000 DB.

Any input on whether the DB is the prob or the host?

http://www.clan-rt.com

- carpe diem -

 

[split27]

Are you sure you've set the modes
database.Mode = adModeReadWrite
You may have a recordset...
Are these properties fixed ?
recordset.CursorType
recordset.LockType

I had problems with constants because they wouldn't be known by IE 4, so I couldn't set the permissions on my database.
So I had to use my own constants :

Const adOpenDynamic = 2
recordset.CursorType = adOpenDynamic
I hopes it helps you.
--
X-) Split.

 

[SashiRaveendran]

when you migrated over to access 2000 you may have accidentally lost edit permissions on your database. May be you have to go and set Update and Insert permissions on the Database or Table