Solved Entering Data in Subform creates a OLE Server or Active X Control Error

[dullster]

My subform was working fine. After I appended the data to another table and deleted the records in that table I started getting the error:
A problem occurred while (database) was communicating with OLE Server or Active X Control. Close the OLE Server and restart it outside of (database), then try the original operation again in (database).

If click ok on that error twice, I can then enter data. I cleared my cache and repaired Office but neither helped. Any ideas?

 

[theDBguy]

Did you restart Access?

 

[dullster]

Did you restart Access?

Yes, several times. I just found an redundant relation. I'm going to try rebuilding my subform and see it that fixes it.

 

[theDBguy]

Yes, several times. I just found an redundant relation. I'm going to try rebuilding my subform and see it that fixes it.

Let us know how it goes.

 

[dullster]

I corrected by redundant relations and rebuilt the form and subform. I fixed my error.

 

[theDBguy]

I corrected by redundant relations and rebuilt the form and subform. I fixed my error.

Congratulations. Good luck with your project.