I have a large application using Access 97. Using 4 of the existing tables, I run a make table query called #1. #1 table generally has 3000 or 4000 records in it. One of the fields called speciality in #1 table has a code number for the foreign county. I want to convert the foreign code number to a english description. 1 of the existing tables called mastercodes has both the foreign code number and the english description.
I added a field call specialtyText to #1 table and created an update query using table #1 and the mastercodes.
Each time I run the query, it shows the correct number of records, but when I click OK, the caution message pops up saying "Microsoft Access can't update all the records in the update query" and then it tell me the number of records access didn't update due to lock violations.
I have tried the following; Open the table exclusive, check to make sure tool-options-advanced shows unlocked, copied the existing tables and querys to another drive/subdirectory and rerun the querys to no avail.
Two burning questions, how do I find out which records are locked and how do I correct this?
Thanks in advance for you help!
I added a field call specialtyText to #1 table and created an update query using table #1 and the mastercodes.
Each time I run the query, it shows the correct number of records, but when I click OK, the caution message pops up saying "Microsoft Access can't update all the records in the update query" and then it tell me the number of records access didn't update due to lock violations.
I have tried the following; Open the table exclusive, check to make sure tool-options-advanced shows unlocked, copied the existing tables and querys to another drive/subdirectory and rerun the querys to no avail.
Two burning questions, how do I find out which records are locked and how do I correct this?
Thanks in advance for you help!
