I have built a database for a local history group photo archive. Because of bandwidth constraints for uploading to the group’s website, I need to export the records in batches of 20 at a time.
I have written a script that works so that if the found set is >20, opens another window, omits the first 20 records on that window, then if the found set is still > 20, repeats until the top window has less that 20 records. So far so good.
Then, it exports the top window to XML, ups the file counter to generate the next file name, then closes that window, and repeats on the next active window and so on.
All works (more of less) ok until the next to the first window when I get a message:
This record cannot be modified in this window because it is already being modified in different window.
Click ok, - that record doesn’t save, but the last one does! Help.