I have a strange issue where most of the time when inserting a record on a form the parent browse will show an ‘Error: (File Not Open (37))’ error message. This sometimes doesn’t happen but only rarely. Please see the attached video for an example of the error occurring when adding a new ‘Person Photo’.
As you can see in the video the record is inserted successfully into the MSSQL database and shows in the list for a millisecond before the ‘Person Involved’ window is closed.
The insert is happening on a form opened from a few parents browses/forms:
– Incident Report Log (browse)
— Edit > Report Detail (form)
---- New > Person Involved (form)
----- New > Photo (form).
Only the ‘Person Involved’ and ‘Photo’ procs contain the table in question ‘dbo.IncPersonPhotos’. Things I have tried:
- Adding the table to the ‘Report Detail’ and ‘Incident Report Log’ procs.
- Turned off the ‘Defer opening files until accessed’.
- Adding access:IncPersonPhotos.open() and access:IncPersonPhotos.UseFile() in various places in the ‘Person Involved’ form.
- Ripping my hair out.
But none of these have worked. Appreciate any help as this has stopped me from progressing for a few days now.
Using Clarion 11.13372.
Thanks and regards,