Hi All,

is there a way to find out if a particular db on the fmserver is open?

basically I want to do the following...

if (dbtest.fp5 is OPEN on the server) then ....

else

msg="the db is closed for repairs"...

Please Help

Zeina

Create a script in the server file with one script step: Close[].

In your other file create this script:

Allow user abort [Off]

Set Error Capture [On]

Perform script [sub-scripts, External "dbtest.fp5" {close script above}]

If [status(CurrentError) <> 0

Show Message ["The database is closed for repairs"]

{Whatever other action would go here}

Else

Perform script [sub-scripts, External "dbtest.fp5" {Open script}]

{If this is an opener file} Close []

End If

Thanks this is awesome...

next question from a filemaker 6 db can I call an external script residing in a filemaker 7 db?

or vice versa?

Z

Nope. At least not natively from either direction. Never tried doing it through some other application, if that is even possible.

Thanks Roger,

I imagine it can be done via scripting...i'll be testing that today

thanks

Z