I'm trying to have a file open via a "perform Applescript" command in a FileMaker script. When the script gets to the point to open the other file, an error happens that says "Data is being accessed by another user, script, or transaction (error -10011).

This other file is not opened at all.

Here is the sample of how I have it coded, I need to open several files all of which start with a single letter, thus the variable part of the name of the file.

open file ("Artist's Drive:Database Files:" & item i of myParaList & "_Scans_Database")

any ideas?

Is this file in use by multiple users?

Also, any other pertinent info (platform, operating system, FMP version, etc.) would be useful.

-Stanley

Okay:

>>>I'm trying to have a file open via a "perform Applescript"

I'm an idiot, you're on a Mac.

-Stanley

I'm currently using FMP 5.5 on System 9.22.

FWIW, the "getURL" command will open the file then from my remote machine, but once I enter in the password the rest of the script stops. :-( I may need to use the "getURL" command to open the files from our FMP server. Is there a way to open the file and include the password? What I have tried so far has not worked, that is, script editor just won't accept a phrase like "with password "Blahblah"

I am using this:

getURL "FMP5://255.255.255.255/Scan_database"

to open the file. (The 255 is the made up machine IP address)

after this Applescript step is done, the rest of the script stops.

Also, the entire script will run from Script Editor perfectly every time. Just when I run it inside the Filemaker "perform applescript" step does it not work.

Or if anyone has any ideas on building the script entirely or mostly in FileMaker's scripting then that would work too. I can post up the code or email you the couple files I am working with, email me at the address below.

Just use the FileMaker open URL statement using the same URL.

Note that this technique can be extended to make a single Filemaker login file open a hosted database with different passwords:

if patternCount(Status(Currentgroups), "admin")

open url fmp5://passwordx@host/Contacts.fp5

else

open url fmp5://passwordz@host/Contacts.fp5

end if

It should work fine. But this would let you see what string you're passing:

try

set filePath to "Artist's Drive:Database Files:" & item i of myParaList & "_Scans_Database"

open file filepath

on error

display dialog filepath

end try

I'm also running into this -10011 error message. I have an Applescript done in Scriptmaker that copies an email address out of a field in FM3 and uses it to send a bcc email in AOL 5 (yes I know they're both pretty old Mac programs). My script reads:

tell application "FileMaker Pro"

activate

set this_email to cellValue of cell "Email" of current record

tell application "America Online"

activate

set documentRef to make new document with properties {kind:mail}

set mailref to mailer of documentRef

set mailRecipient to this_email

make new addressee at end of mailref with properties {kind:regular, name:"reedrichards"}

make new addressee at end of mailref with properties {kind:bcc, name:mailRecipient}

end tell

end tell

Any ideas about where I'm going wrong? thanks

This was a script i used in OS9 to open a filemaker database on another machine. Not sure if this will help your or not with what your're doing but the passsword bit might, this was for connecting to another machine - its in the first line as

eppc://username:password@ip address

Applescript below:

set rmach to machine "eppc://mike:[email protected]"

set rfind to application "Finder" of rmach

set rapp to application "Filemaker Pro" of rmach

tell rfind

using terms from application "FileMaker Developer"

tell rapp

activate

open database "test1"

end tell

end using terms from

end tell