I have a database in which each record represents a story in a magazine. A portal links to a photo database to show photos that go with the story.

To extract data I have an Applescript like so (oversimplified to one field and no repeats):

tell application "FileMaker Pro"

   tell database "Stories"
      tell current record
         set storyTitle to cell "title"
         do script "RelatedRecords"  --Filemaker script: Go to related record; show only related records
      end tell
   end tell
   
   tell database "Photos"
      set oneCaption to cell "caption" of current record
   end tell

end tell

This worked find with Filemaker 9 on Leopard. Now we've upgraded to Filemaker 11 and Snow Leopard. 

And now the above fails on the first attempt to read the related records with "Data is being accessed by another user, script or transaction."  

Worse, *sometimes* it works. For a while. I can sometimes jump start it by scrolling to an earlier record in the database and then back, or by quitting Applescript Editor and then starting it again. The actual script has a lot of looping through records, and when it does work it's good for about 4 or 5 photos and then it dies. I thought "memory issue," but sometimes it just won't run at all, even from a fresh start. Including a restart of the computer.

Suggestions?


Bill Steele
[log in to unmask]