Updating data in a linked table
Unfortunately, this is the way Jet Text ISAM works - it effectively provides read-only access to text delimited files.
If you have tables linked to a backend Access database, and you move that backend database, the frontend database will stop working properly until you update the linked tables in the frontend to point to the new location. I have thought through how to work it without linking data, but that means half the form would be built up of dlookup fields which I understand would slow things down considerably.Has anyone else had this error "Updating data in a linked table is not supported by this ISAM." and who might be able to help me resolve it please.When you open a query in Datasheet view, you may find you want to edit the data.Perhaps you notice an error, or perhaps you see some information that is out of date.