[comp.sys.mac.misc] Big Problems with FileMaker Pro

ts@author.ecn.purdue.edu (Thomas Ruschak) (06/22/91)

	We just got FileMaker Pro a month or so ago, and we're having real
problems with it. The application itself is fine, it has all the features
we need, etc. Unfortunately, our database files continually get corrupted!

	We have the following setup:
		Mac II fx (8Mb), Apple 24bit Color, Mac II ci (4Mb), Apple
		Page Monitor, Mac II si (5Mb), Apple 8bit color

	All the machines are hooked up to an Appletalk network. We keep a
lot of our files on a SparcStation II, using AUFS (apple-unix file system)
We use System 6.something and Multifinder. (I can get the exact versions
if needed)

	Anyway, FileMaker Pro writes to the file from time to time as you
work, and says that you don't need to save, but you do need to make sure
that you either close the file explicitly, or quit the app. Fine, we do 
that. Unfortunately, a lot of the time when we work with the file, everything
seems to go fine, but then when we try to re-open it later, we get a message:

	"This file was not closed properly, attempting minor repairs"

	These 'minor' repairs don't work, and then we get a dialog box that
says the file is damaged, with a resume and a quit button. The resume button
sometimes allows access to the file (rarely), but usually just brings the 
dialog box back up... The quit button quits.

	Now, the manuals say that when something like this happens, you use 
the 'recover' function. Sometimes it works, sometimes it doesn't. For example,
sometimes when you attempt to launch the recovered database, it hangs the Mac.
Sometimes when you recover a 490K database file, the recovered database size is
6K! Lately we've been getting more serious errors:

	"This file is badly corrupted or is not a FileMaker Pro file"

	Yeesh!

	The errors happen much more frequently when we keep database files on
the remote AUFS drive, but they still happen, even when working on a local HD.
It is possible that AUFS is off somehow, but we've never had ANY other problems
with it, and it is in wide use here...

	When I called Claris, they suggested:

	1) Raising the memory on the app to 2Mb. I did, no joy.

	2) Cloning the database (i.e. writing out the definitions without any
	   data), and then exporting the data to it. (They said this would
	   result in a 'cleaner' file ?!?) I tried this also, no joy.

	Any help will be gratefully and humbly accepted. It's a nice app, does
all the things we want it to, but it's unusable this way! Fooey.

	BTW, thanks to all those who helped me with my MacDraw problem. Works
fine now!

                                Thomas Ruschak
                                ts@ecn.purdue.edu
                                pur-ee!pc!ts

"We don't care. We don't have to. We're the Phone Company" --- Ma Bell