anna f

What causes it? Did you ever find out? Even with a daily back up, I am losing a lot going to the back up. Is this a glitch or something that I did? I have been up without a major issue for 2 years (24/7 use of files, too). Very disconcerting...

Has anyone ever had their entire relationship graph disappear? My hosted FM 8 file (Server 7 Adv), just this one out of 15, has all the records showing in define database but the layouts are unusable (table missing) since I have absolutely no table occurrences anymore! Can I restore the graph from a back up? It is a day old back up so I would rather keep all my current data and just restore the relationships. Help!

Has anyone ever been able to get the Server Admin Tool to show clients by FM account name instead of computer name? I know one can have a different account name for each file hosted but we go through Terminal Services which, of course, shows everyone as coming from the same computer name (and same IP, etc.). It is a big pain not knowing who is who. Any suggestions? Thnx.

Experienced Filemaker (7/8) developer needed immediately for a new, permanent position in Charleston, SC. Knowledge of XML, PHP, and the medical field very helpful (organ/tissue donation.) Our database sytem and user needs are exploding. Great benefits and opportunity with an exponentially growing company. Email inquiries to Anna Fletcher, Director, IT at fletchera@lifepoint-sc.org.

Brilliant. Thank you.

Is there a way for a script to tell if a user is in Find mode when the script is executed? I need the script to do something different if executed in Find mode (some of my check boxes are buttons). Thnx!

Thanks- this worked like a charm and was simple, as I suspected. I didn't try the Choose suggestion yet but I will. -A

I am having a brain blurb- how do I convert a time (x:xx) into a decimal? I have a calc field that shows the time elapsed between two dates/times in hours:minutes. I need to count how many records have a time of less than 1 hour, between 1 and 3 hours, and over 3 hours. Thnx!

Thank you- although I do not have access to a Mac, I did run the report one section at a time and found out the hang up is when running layouts. I only have 204 which I do not think is too big. If there are no known bugs with this, I will continue to try different things. Again, thanks for the reply.

I am using FMP 8 Adv. to work on a file hosted by FMSA7 on a Windows platform. I have run many DDRs for this file but recently it has been hanging up before completion. My only option to to end task as FM becomes unresponsive. I have tried it with Dev 7- same thing. I have tried it from other computers- same thing. Any suggestions?

Hi! I have a layout for performing finds that looks identical to the entry layout except no pull-downs and no functional buttons. My Find script takes users to the find layout, enters Find and pauses. User enters criteria, resumes script with a button and user is returned to entry layout. If no found set, I have a mssg and user goes back to entry layout. However, the native FM mssg for no found set allows a "Cancel" which leaves users on a mostly non-functional layout. How do I bypass the native FM mssg? Or get rid of the "Cancel"? Modify find and Continue are okay.

Is it possible to make a value list with script functions as the choices? Or calculations? I would like to make a drop-down that allows a user to choose which layout s/he wants to go to (without having to additionally click a "Go" button after choosing.) Thnx!

Thanks- I'll set up a schedule for a restart daily. It's still weird that only one of the two hosted IWP files had the problem, though.

I have two db published via IWP (FMSA7, IIS on Win2000 TS). One works fine, just the usual web quirks. The other one gives intermittent login problems. Some days users get "Error 13" (file or object is in use). If I restart the Server, the problem is fixed- temporarily. I shouldn't have to restart FMSA several times a week, though. While one db gives a login error, the other does not so I know it isn't Server or WPE. Anyone else have this weirdness? Any ideas on it?

The best way to control field access is through Account setup, like Lee suggested. Go in, create a new priv. set and you will be able to customize access to tables, layouts, scripts, etc. If you choose to customize table access, you will be taken to an area where you can assign field-level access (or the lack there-of, as in your case.) Your other option would be to create multiple layouts and leave the "private" fields off of one and only allow certain users access to that layout (but again, done through Accounts). Your other users, who can see the fields, will go to the "full disclosure" layout. I'm sure there are other ways but FM7 has a good security system and I utilize it as much as possible. With field-level access controlled through Accounts, it doesn't matter how a user accesses the layout. Hope this helps.