Hi,

I have a database that thows strange read-only errors.
For Example a

Update Adress Set KundenNr='002' Where ID = 1
results in
ElevateDB Error #1000 An error occurred with the cursor Adress (An attempt was made to update a read-only cursor)

or
ALTER Table Adress READWRITE
results in
ElevateDB Error #403 The database xxx is read-only and this operation cannot be performed (ALTER TABLE Adress)

The same happens with all tables in the database.

A
Select * From Information.Tables
shows me that the tables are not readonly

I don't know what happend to the database, but how can I remove the readonly state?

Regards
Burkhard Schneider

Burkhard


Have you checked to see if they are read-only on disk and that you have the correct OS permissions in place?

Roy Lambert

Roy,

yes. The files are not read-only and I have full access

Burkhard


Hopefully a silly question - is the query set to read-only?

Roy Lambert

No

Burkhard


Final things I can think of:

1. Try repairing the table in case it corrupted
2. Copy the files making up the table to a new folder, delete the originals and copy back

after that I'm lost. The only one that I used to encounter was copying from a DVD/CD when all the files came over as read-only

Roy Lambert

Roy,

thank you.

After allt the problem were missing OS Permissins. Althougt I could create and modify a text file, in the properties of the folder, Tab security, there were no write-persmissions for the windows user.