Unable to edit linked tables 1

[RDVeron]

Greetings,

My Access 2000 database runs only on my WinMe computer. It contains both Access and linked dBaseIV tables. The problem is that I am unable to edit, sort, add or delete any data in the linked tables. The computer tells me "This Recordset is not updateable." I am also unable to run more than one query based on the same linked table at the the same time. The computer tells me "The database engine could not lock table 'Tape4#dbf' because is is already in use by another person or process."

I have already checked and none of the files used are marked as read-only. I have also tried to delete the link and re-link the table to Access. I am still able to edit the dBaseIV files using other applications (AtlasGIS). Based on other postings I've read, it could be the permissions used to connect through ODBC are incorrect, however I am unsure as to what they should be set at.

Any help would be greatly appreciated. Thank you in advance.

Rich

 

[RDVeron]

I finally found the answer on the Microsoft website. Seems that I needed the Jet Database Engine 4.0 Service Pack 5 or greater (Jet40SP6_WMe.exe) in order for the files to be handled the way I wanted. Hope this helps others out as well.