AnsweredAssumed Answered

Importing records between tables in a file on a server

Question asked by VirginiaPollard on Jul 17, 2014
Latest reply on Jul 22, 2014 by philmodjunk

Title

Importing records between tables in a file on a server

Post

     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!

Outcomes