INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Error Messages

Access communicating with OLE server or ActiveX Control error msg by paron
Posted: 4 Dec 02

I was getting this prompt. From a search of the Tek-tips forum, a lot of people get it, in totally different situations, and virtually none of the posts were replied to.
It seems to be the Access equivalent of a nervous breakdown or something.

JuanLoco (Visitor) says "I fixed it by making a copy of the offensive form, deleting the original, and then renaming the copy to the original name."

Well, chapter two here. JuanLoco's suggestion helped, but my app went south again after adding one record. Happened repeatedly until I:

made a blank db,

imported all but the offending form and two ODBC links that seemed to be getting trashed as well,

rebuilt the links to the two tables on the back end (don't import and use Linked Table Manager -- delete 'em and make the links again:  the problem seemed to be related to Access losing track of the unique fields in the backend tables when the offending form was used.)

and finally went back to the original database, copied the offending form, and pasted it into the new database.


YOW!  

Importing the form directly didn't work, and neither did importing the links and using Linked Table Manager. Very odd. Wierd and scary. But it's working now, and seems stable.

Ron
 
 

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close