Hi

I have an application where several instances of a program may be running at the same time. They all write to the same log table. If another executable, which also has the log table open ,is also running on the computer at the same time, inserts a record into the log table are somehow stopped until I exit that program.

The strange thing is that I can open the table via the VFP IDE and add/delete records as I like. I have put debug messageboxes in the program and they show that the table is not locked yet the program hangs at the insert command (The problem doesn't happen if I am using the debugger)

Has anyone any idea why this might be occuring?

Regards
Geoff Scott