Ian Vee

I've finally licked this problem (It's only taken about two years). The buffer overrun only happens when my cursor is left in a container field. That factor is the key trigger. I use literally hundreds of macros and scripts toggling between MS Word, Excel and FMPro. (This crashing only happens on a PC, by the way -- as I use both Macs and PCs). My solution is that whenever I run a script that uses one of my container fields, I end it with "Go to field []" (i.e., with no field specified) so that my cursor is never left in a container field. I started adding this to all my scripts about 6 months ago, and I encountered my first "buffer overrun" in six months today. I quickly scanned the related script and noticed that the "Go to field []" script step was not added to that one script. So I'm fairly confident I've nailed down the solution, even if I don't know exactly why leaving my cursor in a container field creates such bugs.

I'm going to answer my own question here, since I just solved it. Silly me: Everything works fine from our XP machine here. It's just the Mac OS X machines that have a driver that restricts the amount of data that can be imported into any one field (I guess it's the wrong driver--full compatability is not supported). It's funny that everything else worked so well with the wrong driver.

I'm importing from an OBDC data source (MySQL), and I'm sure that the data in many fields is longer than 312 characters on the server, but for some reason, when I import FM7 is only grabbing a maximum of 310-312 characters and then cutting off with every field. I've checked the field definitions in FM7 (text) and validations (none). I don't know very much about the server I'm pulling from (it's our website hosting company, and I'm trying to pull back the data I posted there using a browser). Is this most likely an FM7 problem, or could it be restricted from the other end? Ian

Thanks, people. I think the process that's causing the trouble is my Outlook e-mail checking now, but I'm not sure. But I'm curious, transpower, what is the reason that "programs" is the default memory usage, if "System cache" would work better. I'm afraid I probably won't know whether it works until the weekend, when I have another batch of files to process, but thanks for the suggestions, Ian

I do a lot of work in MS Word for one client, and I use FileMaker 7 to manage and check the complex web of files she sends me. My problem is that FileMaker infrequently (every 25 minutes) crashes with a "buffer overrun C++ runtime error" message while I'm working in MS Word (2000). I have no idea what this error denotes (i.e. a problem with Word, Windows, FileMaker, or some combination), but it's only FileMaker that crashes, and it's only while I'm in Word. On restart FileMaker works fine for a while again. There does not appear to be a trigger (perhaps a simple "find" request, but not always). Has anyone seen this? I can find no posts on it (somebody had a vaguely similar problem in photoshop.) Here are some potentially influencing factors: I run huge complex macros in both Word and same for FileMaker (i.e. scripts automatically create citations for 100s of references in Word and the convert them to Excel for auto checking--it's a highly technical textbook, by the way). The crashing happened slightly more frequently before I update to SP2 (Windows); it happened also with FM5 (my previous version). I use many container fields with embedded shortcuts to the files as stored on my hard drive. Any theories would be appreciated.

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.

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?

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.