One thing to note is that once a table is open, opening it again occurs very quickly. I do not know that I will ever again write a VFP app using PRIMARY keys. If you ever get ay data corruption your primary key is most likely trashed and then there is a strong chance that the app just will not work!
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!