Importing records between tables in a file on a server
I want to use Import Records in a script to move data from a found set of records in one table into new records in another table in the same file.
This works perfectly in a test sample script I wrote using a clone of the main FMP file on my local PC. But the file I actually want to use this script in is on a server and is sometimes shared. When I try to run the script on this file, I get an error message at the import step, saying that the file is already in use and can’t be opened (yes, it’s in use by me.)
The only difference between the script that works and the one that hangs appears to be the location of the file (local vs server.) Is there a way I can get around this problem? Thanks!