Database Error

[legolas]

Hi,

I habe a FM database which can be opened from a server share(not remote host), the file Server is a Mac OS X Server 10.1. The db itself is shared for Multiuser.

Then we have a OS X Pather with FM 6 und Jaguar with FM 5.5. Both of them can use the FM db as a mulituser with any problems.

And there is a Windows2000 PC with FM 5.5, the PC access the server volume with the SMB protocol.

So, here is my problem:

When the pc user opened the FM db first, then it will be shared as a multiuser db and mac user, when they click on the db, the FM recognise the multiuser share from the pc and open it remotely from there.

But if one of the two Macs open the FM db first and the pc user click on the db later, the pc FM client doens't recognise that it was opened before. So the pc FM client open the db directly from the server share again and the db goes corrupt.

Does anyone knows the problem/solution?

Sorry for my bad english....

[transpower]

Disallow the PC from accessing the server share directly.

[QuinTech]

Hi, legolas. I'm not sure i followed you perfectly, so forgive me if i'm telling you something you already know. FileMaker files should never be opened through file sharing. This is such a bad idea (as you can see from the corruption that occurs) that the folders that the files are in should not be shared at all.

Your best bet is to host the files using FileMaker Server. FMS will open the files for hosting, and you will need an Opener file to find those files through FM's networking capabilities. You definitely do not want users double-clicking a remote FM file under any circumstances.

If you don't have FileMaker Server, the next-best option is to open the files remotely as if the machine that opened them first was the server. That is, the first step MUST be to open the files locally wherever they are actually stored. Then, if you want to access them remotely, use the Open Remote function to open hosted files. Keep in mind, though, that this method still involves some risk and degraded performance. It should not be viewed as an alternative method, only as a temporary workaround.

HTH,

Jerry