Pervasive Sql unlock read only table (1 Viewer)

[craigachan]

I have Pervasive Sql v10.30 BackEnd and connect to my Access FE thru ODBC. I have some tables I can open and update records in the pervasive db, but I have encountered a table that when I try to rs.edit/rs.update, says its read-only. I've gone into the Pervasive Control Panel but don't have much experience in making changes. I'm wondering if anyone can help me unlock this table if possible? Any help is appreciated.

 

[jdraw]

This may help if the recordset is read only. I don't know Pervasive, but am wondering if Allen's material may hold the answer, or some insight.
Good luck.

 

[craigachan]

Thank you for the tips. Since I couldn't change the index's to the Pervasive db, I did check the index links with the Access tables and found that there were no links. I unlinked and then re-linked the table. The link wizard then gives you a choice of identifying the indexes. Once I identified the indexes, it started to work and I could change data.

Thank you for your help.