Can't Delete Records on Server 7

[FMDuck]

Hi All,

On both an OSX server and Win 2003 Server I seem to have often but intermittent problems with not being able to delete records. This happens in different databases at different locations that have nothing in common other than they were converted from FM6. When trying to delete a record either from FM directly or from a script step, the client just hangs and does nothing. No hour glass, coffee cup... nothing. I once had a client reboot the entire network and there was no change, but then about an hour later the problem just went away and everything deleted normally.

The problem doesn't seem to exist when the database runs locally but since it is intermittent (but often) it's hard to tell for sure if Server is the culpret.

Thanks much.

[Vaughan]

FMP 7 handles record locking in a different and more explicit way than earlier versions. It could be that one of the converted files is opening a record but then not closing it again.

[FMDuck]

Sounds reasonable but it doesn't look like the issue. The solution at my office that has the problem is a simple contact management that only opens 3-4 files. As luck would have it, as I'm testing now, records are deleting with no problems. Only one file is directly interfaced and often I'm the only one accessing the database. When the problem is occuring, I can reboot the server and my PC, restart the database, navigate directly to the record to delete (without activating a script or changing layouts) and the lockup still occurs.

[Vaughan]

The only other thing I can possibly think of is that the files on the server are being opened by another program and becoming locked. That's a big guess.

[NRCM]

Has anyone figured out a solution to this one?

Some folks on my system were complaining about this problem last week, it would work fine on my computer but not theirs. Now mine too is having this problem of not being able to delete a record and locking up FileMaker solid, requiring you to force close FileMaker.

[Vaughan]

Take the files down and check them for corruption. It sounds like something is not right.

Make doubly sure the dbs can only be accessed through the Hosts or Open Remote command in FMP, and not through Network Neighbourhood or Windows Explorer.