OK big guy, you've done me a good service. I've actually been able to close a database using a browser and the "-DBclose" tag. But (of course there's a but) I haven't as yet been able to use "-DBopen" to start one up, what gives? I moved the files I'm testing to the 'Web' directory, setup multi-user access with the appropriate uid/password combos and still nothing on the "-dbopen" front. Any other clues?
Thanks, E.
quote:
Originally posted by jwtidwell:
Well, here goes....You can't technically "start" or "stop" a database from the web through Web Companion because in order to do that you would have to have access to the Multi-User sharing capabilities of FMP. With that said, the obvious way to "stop" or "start" a database remotely is to "open" or "close" the database using: "-DBOpen" and "DBClose" since a database is only shared when it is open. Here is the complete info for the commands...
What it does
Closes a database on the FileMaker host machine from a remote browser.
The -DBOpen and -DBClose actions tags would only use the -db variable tag for the name of the database and the partial path before FMPro? in the URL to determine on which database to apply the action. The database administrator will have to have remote administration privileges and the database to be closed must be in the Web folder. A format file is required to be specified in the URL in order for -DBOpen to be processed.
For security reasons, it is important to use the Remote Administration Requires Password option, otherwise users can close your database without an Administrator password.
Syntax example(s)
Close a database with a URL
HTTP://thehost.com/FMPro?-Db=Employees.fp5&-format=aFormatFile.htm&-DbClose
HTTP://thehost.com/asite/onlineordering/FMPro?-Db=main.fp5&-format=aFormatFile.htm& -DbClose
Other tags that are required
-DB, -format