I have been operating for years under the assumption that FMP Server 3.0 can host FMP databases of version 3.0, 4.0 and 4.1 without any problems.

My assumption has been that the scripts and calculations were performed on the client machine and that the server just held the files open.

I have been asked to troubleshoot a database which I didn't develop.

It was written in FMP 4.0.

It is used for scheduling equipment check out in a library.

The script which checks for conflicts for reservation date and time works under 4.0 and 4.1 - but fails to work when the databases are served by a FMP 3.0 server.

Any ideas?

Cheers,

Marcia

This is kind of a "I have a patient who is sick, what's wrong with him?" question. How about a look at the patient?

Your assumption is correct. There are, however, things you must take under consideration in writing a solution for a multi-user environment. Globals are one case. In a single user environment, they can be used to store default values. Not so in a multi-user environment. The problems your are encountering are probably related to some such problem.

-bd