Some files not showing up with "open remote"

[Ian Vee]

This is my first experience posting, and I'm new to FileMaker Server too, but of the 54 tables I've just installed on my server, only 35 appear when I "open remote" through FM7. I can't find any related threads on this topic on this site.

Here are some of the things I've checked:

My configuration (Mac OS) is set to allow 125 tables.

All files are have the same read/write privileges

My data log file clearly says all 54 tables "opened".

My FileMaker Server Admin program also shows the files as opened. But I can't locate them all using FileMaker 7 for some reason. I see no pattern comparing the ones that don't appear versus the ones that do.

By they way, all files are in the same level folder (one down from the main level--in a subfolder in other words).

Please help.

[Reed]

What about filemaker privs? Are you using external authentication?

Are you sure that the "Don't display in Open Remote dialog" box is unchecked for all files?

[Ian Vee]

Thanks Reed,

I got it working. It has been years since I created these files, and it looks like I neglected to set the Network Sharing "Network Access to All Users" to "all" on some of them (that did not need to be shared in my pre-Server days).

So thanks.

But now I'm having a totally different problem. I'm trying to update my tables, but one of them crashes every time I try an import. It's a simple table with only about a dozen fields. But after 500 records import (out of 4500) it takes down the entire FileMaker Server 7 (including other tables). I tried importing using DIF and FileMaker 7-native files. Both fail at exactly 500 records.

Is 500 records to import some kind of limit?

[Reed]

I routinely import thousands of records with no trouble, although I have had imports fail on me in some cases. (It never actually crashed the server or client though) I always was able to figure out the problem by importing half of the record set at a time and isolate the bad records.

Dana

[Vaughan]

I've found that some files that work perfectly well in FMP refuse to be hosted in FMS. Invariably the file has some sort of data corruption, often from being shared on a network volume.

The solution is to recover the data then import into a known-good clone. The challenge is often finding a known-good clone.

[Ian Vee]

Thanks again Reed,

I deleted record numbers 499, 500 and 501 from the source data file, saved the target file as a clone, then imported the (slightly smaller) source data set and it worked perfectly.

Again, your advice has been invaluable.

[Boo]

Hi,

I added a new file/table to my application but when I try accessing it remotely, I get an error saying The file is not there. I am using FMP 5.5. I wanted to know if i have to set any preferences/permissions???

Also I cannot see the file in "open remote"

Thanks,

Boo

[QuinTech]

Hi, Boo. Did you add a new file or a new table? Are you using Filemaker Server? (If not, this is definitively the wrong forum for your post. Try the Filemaker Version 6 forum.)

I think you will be better off creating a completely new post, as this is seemingly quite unrelated to the original poster's issue. It's just cleaner for us to deal with it as such. When you do post, please specify how you intend to share these files (FMS? operating system?).

HTH,

Jerry