Phil,

>Hi,
>Still having problems. The function that adds the new record to the table now checks whether the unique key already exists by using the seek function. Despite this the problems are still occurring.

Did you perform a test like I suggested in the last paragraph of message #694345 ? If not, you really should do it. Furthermore, incorporate as much as possible from the logic you normally use in the app. By looking at the screens, you possibly don't see it flaw, but you might learn better where things could go wrong.


>I was wondering whether duplicate ip addresses on pc's might have something to do with it but I'm not sure exactly why or how, I'm just clutching at straws.

Like Ed implied, you'd be having all kind of other problems. I don't think this can run without immediate notice.

>I have been reliably informed that the problem never used to occur before we moved over from a Novell network to NT. Can you think of any reason why moving over to NT might cause a problem?

Tests as I perform them, are always on Novell. However, the logic to apply as learned from it, are present in our app, and I never hear anything about things not working. And, IF something's not working properly (e.g. "I added this key but it doesn't show on the print at the expedition department ... but some later it did") it's always Novell. By other means I can prove this too. It's a difficult area and involves about all you can think of. But it's Novell (or it's clients used ... wrongly).
Anyway, from this we should learn that both Novell and NT act differently, and in your case it may work against you.
You should really setup a test that behaves like your applied logic. I am almost (and still) convinced it is your logic doing wrong somewhere. That is, opposed to the internal workings of all around your app, including Fox.

Concentrate on the Seek upon a record just added by the other instance. I am, again, convinced that within half an hour you can get the thing at will.
Unless you have some real hardware problem, then you may be looking for ages.

Good luck Phil,

Peter