Random Crashes and Empty Search Results

[Paul Peil]

Hello all,

About every other day or so, a FMP-6 database I built crashes while doing a date search on about 8000 records. It also will randomly return a no records found response to a known good date range when the starting point is all records. The random crash is corrected via "Recover" while the no records found problem is recovered via a re-start of the Host CPU. The system is configured with a 2.4 GHz P4 CPU, 256 MB ram, 40 Gg Hard drive and running Win 2K. Machine as the host with no other apps running. There are 5 other clients (also Win 2K)on the system doing routine queries on the database. They each open via the "Open remote" command. The clients have never failed when the above queries are made. We thought it could be a computer problem, so we removed the old computer and installed the one described above. However, the problem persists. The host and all clients are running FMPRO6.0. Anyone have any ideas?

Thanks

[Anatoli]

1. Get FM server

2. Check/Repair your database. Save as clone, export records as text and import that text file into FM clone.

3. Do not use Recovered databases.

[Paul Peil]

Anatoli,

Thanks for the quick response to my problems. I have asked the person who uses the host to use her backed up copy of the database when it crashes vice using the recover option, she backs up the database to another machine hourly. So far, this gets her back on the air with minimal loss of changes. Do you think a faulty database would only show up on the host? The users on the client machines do the same stuff query wise that the host user does and have never had a failure. In fact, when the host gets an empty search result, she asks the clients to run the same search and it works fine on their machines.

Thanks again.

Paul