Greetings,
I've found several questions about creating a file to open a remote filemaker db.
How do I modify that script so it opens a specific database instead of just opening the open remote dialogue box?
Thanks,
Sky
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
this is how it ended up working best:
Make a new shortcut on the desktop and in the location box enter something along the lines of:
"fmp7://myservername.com/m
When activated this shortcut will open FMP 7 or 8 and open the DB requested.
If you want "auto" login features use the syntax of:
"fmp7://myusername:mypassw
This is good instructions for creating the "opener" db file
http://filemakertoday.com/
Re: FMP Automatically Open a Specific Database
--------------------------
a) Create a new blank FileMaker database file. Don't bother making any field definitions, you won't need them.
b) Go to File Menu, Define, File References. Click "New".
c) Click "Add File". When the "Open File" dialog comes up, click "Remote..." yes, I know this is what you're trying to avoid, but you're only going to have to do it this once, trust me on this
d) Navigate to the file, select the file that is to be opened, click 'OK' or 'Open', whatever it is that the button says.
e) In the blank where it says "File Reference Name", type the name of the file. Leave off the file extension.
f) Click "OK", and "OK again, which should get you out of File References land.
g) Open ScriptMaker. Create a New script, "Open Solution". Use this script:
Set Error Capture [On]
Open File [<select it from dropdown list. The file reference you created>]
If [PatternCount(Databasename
..Show Custom Dialog ["Unable to open the solution at this time. The server may be down or the IT guy may have tripped over the router again. Call 555-1212 if you have any questions." "OK" button only.]
End If
Close [current file]
h) Exit out of the ScriptMaker. Go to File Menu, File Options. Set the option for the script you just created to automatically run whenever this file is opened.
i) Email copies of this file to all users.
Now, as for passwords... my strong advice is "deal with it", unless you want all of your users to have the exact same privileges and the exact same ACCOUNT within the solution. If that's actually the case, just open File Options for the solution file itself and set the file to automatically open using the specified ACCOUNT. Then it should not ask you for username and password. If you want to bring up the dialog after you've done that (to log in with a FULL ACCESS account and password, for example), hold down the Option key on Mac, SHIFT key on PC, until the dialog comes up.
Business Accounts
Answer for Membership
by: lesouefPosted on 2007-08-29 at 08:48:19ID: 19792462
create a fileref for the remote file to open in your launcher file.
indicate the fileref in the script which opens the remote file.
for instance a fileref for a file called database.fp7 on a remote server may look like this:
fmnet:/www.yourserver.com/
or
fmnet:/80.12.12.123/databa