>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.
>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.
Duplicated IP addresses would cause the network (atr least the two systems with the IP address collision) to stop working rather suddenly and irretrievably. You need to make sure that only one station is using a given IP address on a given net at any given time (with DHCP, the same IP address might be assigned at different times to different stations, but the DHCP server would be responsible for ensuring that no client currently holds a license on an IP address before assigning it to another station.)
>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?
Cache coherency is a possibility; try to have your network people increase the number of simultaneous sessions, turn off deferred writes and NT server-side data caching.
>
>Phil.