Loading a a FMP table in batch

[Daniel Paquin]

I have an Applescript program which read the content of a directory. Each files contained in the directory becomes a record in a FMP table. It is used to fill the Product table.

All of this process is done behind the scene in batch.

I do have a problem and do not know if there is a solution.

In order for all of the information to get loaded in the Product table I must ensure nobody is accessing the file either from via the layout for the Standard form, a Table view and a List View. If someone is accessing the Product table at the same time the batch program is starting the load nothing gets loaded in the Product Tbale.

Is there something I can do to make this working?

Thanks in advance!

Daniel

Applescript program

.

.

try

tell application "FileMaker Pro Advanced"

do script "LoadProductTable"

end tell

end try

End Applescript progran

LoadProductTable: Perform Applescript

[

repeat with i from 1 to count of sortedMPGFiles

set theRecord to create new record at table "Products"

tell theRecord

set cell "PictNo" to (text 5 thru 8 of item i of sortedMPGFiles)

set _PictNo to (text 5 thru 8 of item i of sortedMPGFiles)

set _SubFolder to (text 5 thru 6 of item i of sortedMPGFiles)

set cell "OriginalName" to (text 5 thru 8 of item i of sortedMPGFiles)

set cell "PathVideoFile" to "/Users/UserName/" & _SubFolder & "/AVI10" & _PictNo & ".AVI"

set cell "Category" to "Video"

set cell "Status" to "Loaded"

end tell

end repeat

]