Using NT 4.0 network server, while making a basic change to a shared database file and updating approx. 2000 records, network communication for this file only ceased, now when opening, or trying to open the file I get the following...

"Filemaker cannot host a file because of a network error, files marked as multi user will not be available over teh network"

The file in question is one of 20+ that are still available, and I can copy/view/manipulate the file in question seperately - any insight would be great, thank you.

"Using NT 4.0 network server..." you are not mentioning how do you host the file...

OK, if you will restart the NT server, will the FM server service start?

Will all files open as multi-user?

Did you salvage or rebuild the file with problem?

Sorry, maybe my jargon is a little off. The files are located on an NT Server box, running the FM5 Server service, is this what you are referring to?

Thank you for the advice, a recovery done on a workstation (as opposed to the server for some reason)fixed the file.

Now if I can only determine how to define a field to calculate as desired, all my problems are solved. I want to increase or decrease a muliplier based on the date a record was created, for example:

if a quote was created after November 1, 2001, I want the shop rate to be $10 per hour but if a quote was created before Nov 1, I want the current records to still reflect $5/hour in order to keep older quotes valid.

If

Else

Endif

should do.