linked tables and "recordset is not updateable" error

[uday]

Hi all!
I'm sure this is a familiar story to you all. I've spent quite a bit of time building this front end using MS access and VBA. All my tables are in MSSQL7.0 and are linked into access. Every now and then access just decides to make the table "read only". I have to actually delete the linked table and re-do it to make it updateable. Is there any fix for this?

regards
Uday

 

[raindrop3]

Hi,

just a guess... If you update the tables by a form, check the RecordsetType. If it is snapshot, you can't update a record set. Change the recordsetType.

Albert

 

[uday]

Thanks Albert, It turned out to be the way access works with linked tables. Just for the benefit of all >>>note<<< when you link tables from access, make sure the original tables have keys defined correctly and indexes built on them. When you link a table into access and access prompts you to select column/s as key/s for the linked table, ITS A WARNING!!!!! Stop linking, go back to the server where the original table/s reside. Ensure you have PKs correctly constructed on the appropriate field/s and then attempt to link again. Access should never ask you to select column/s as PKs while linking.

Regards
Uday