Web Development

Ask something
Discussion Locked

Access 2002

0 helpful
5 replies

by makita

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a database to keep track of inventory and inspections. I have a checkbox that if checked another form should open. Everytime I try this I get an error "A problem occurred while Microsoft was communicating with the OLE server or Active x Control. Close the OLE Server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access". What am I doing wrong? What event procedure should I use? Right now I am using Lost Focus butI have also used on click.

TIA

5 replies

by mjgtennis

Do you have Norton Antivirus running on this system? If so, you want to go into options and clear the script blocking.

by joseph moore

So, this is a problem that many people have apparently had, but with no real solutions. A Google web search has 3 pages of this error, with no luck in fixing it.

So, here are a few suggestions.

1) Upgrade Access 2002 to the latest Service Pack level. On the machine that has this problem, go to http://office.microsoft.com and click the Check For Updates link on the right-hand side.
There is probably an update by now.

Now, I "really" don't think that this will fix it, but it would be good to do it just to rule out service packing!

Ok, what you really will need to do is make another database, and Import all of your data from your current broken one into this new one. Import the Tables, Queries, Reports, Macros, Modules, then the Forms.

You see, there is an error in the db itself (IMHO) that is causing this. So, make a new db, import your data into it, and HOPEFULLY this will fix it. Importing the Forms into the new copy might bring the error into the new database copy. So, if you could recreate the forms that cause the error, that would probably be the safest way to go. If making the Forms is too difficult, then try the import and hope the error does not come over!

hope this helps

This discussion is closed to new replies.