OLE Server Error.. Sometimes

[gmmolina]

I am working on a new asset database. I have a simple Macro that is working... sometimes. I am using the action OpenForm to open a form for a specific ID from another form. I get the error:



"A problem occurred while "file name" was communicating with the OLE server or ActiveX Control. Close the OLE server and restart it outside of "file name". Then try the original operation again in "file name". Error ID 502753".

However, if I close Access and re-open it without enabling content (security warning for VBA Macro) then the Macro works. That is the only "programming" in the file so far. The file location is added in the trust center.

Any other ideas? Thank you!

Gabriel Molina

[NTC]

If the Access file's folder is added to the trust center - then you should not have to enable content nor be presented with the security bar at all to make that choice. You might check out the folder permissions at the operating system level.