Question OLE object causing occasional random errors

[Trystyn]

Hi,

Currently have a database set up as follows:

MainForm containing:

Subform1
Subform2
OLE object (Spreadsheet file)


Subform 1 is linked to MainForm via the field Year
Subform2 is linked to Subform1 via a field in MainForm which shows the current record in Subform1
There is also an OLE object (Image file) in Subform1

I am having a problem because occasionally I get the following error message being caused by the OLE objects in either MainForm or Subform1:

"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time."

This is not the case, and once I get the message the only way I've found to stop it is to delete the record to which this happens (It won't permit me to only delete the OLE object within the record).

It is never the same record, it just seems to occur at random. I would appreciate any feedback on what could be causing it and how to prevent it.

Thanks,

Trystyn

 

[ghudson]

I would change the setup and import the spreadsheet when ever you want to update the table instead of linking to the spreadsheet. You can easily automate the process with the transferspreadsheet command.