We have a labor table in VFP that is written to whenever employees clock-in or clock-out. This works fine, however, we have another VFP app that needs to update a set of these records to indicate that they have been processed (imported into our ERP system). The problem is that if this "import" program is run during lunch time or break time it often causes an Error 108 "File in use by another user". I have tried APPEND and INSERT and both result in this 108 error seeming to have to do with Record buffering/locking, etc.

Does anyone know a way around this? I've tried using the REPROCESS but then it seems to cause the labor entry system to get the error instead of the "import" system.