>For information (from my initial testing):-
>
>For embedded objects, getfldstate() changes immediately when the object is saved / updated / closed.
>
>For linked objects, getFldState() changes only when moving off of the object on the form (i.e. losing focus):-
> when the object has not been edited
> or
> when the object has been edited
> or
> when the object is closed and then the focus is lost.
>(in other words, just about all the time!)
>
>It remains at 1 if the object is saved (in its own application) the table is updated and the object is edited again (in its own application).
>
>This is going to be fun, I can tell!

I hope you did have some fun in your dealings with the OLE creatures.

I am just about to enter the same area, I cannot put it off any longer, and if you have some finding to share, I'll be more than happy to hear from you.

Our clients will save a large amount of embedded documents in a table, mainly Word documents. Once saved the users need to be able to open the documents and edit them, and they need to have more than one document open at the same time. To make this possible I am considering using the document table AGAIN as many times as needed and link every alias to an ole object. I just started trying this out and it seems to work.

However, I also need to set a flag on the documents that the user have changed. When you were looking into the GetFldState, did you find a way to know if a document connected to an ole object was open, and if it wasn't, if it had been changed?