Communicating with OLE server and Drawing Joins

[jtvcs]

In our training room this week where we recently re-imaged the hard drives of the PC we had the following two problems. Hopefully someone can shed some light on ways to correct them. We are using Access 97 and Windows 2000.

1) After opening a database, then when opening a table the students get the following pop-up dialog window: "A problem occurred while Microsoft Access was communicating with the OLE server. Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access." Once you clikc on this message Access seems to carry along fine. Although it can pop-up again later.

2) When on the Query Design screen, a user cannot 'draw the join' between two tables. Auto-Joins work, but hand-drawn ones don't. Any ideas ? Could it be related to item 1 above ?

Thanks for any suggestions. JT

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52994&highlight=OLE+server

 

[jtvcs]

Rich

Just reviewed the thread you pointed me to. I understand that thread I've seen that problem in A2K. But it's NOT the problem I've described here which is in Access 97 and the databases have NO module code whatsoever. Any other ideas ? JT

 

[Rich]

One tends to suspect the db has become corrupted, have you tried importing into a new blank db, remember to compile and save all modules

 

[jtvcs]

Rich

Actually each user has s separate copy of the databases on their C: drives during class. The databases are all clean, compiled copies which we start with. And by the way two of the 8 PC's don't have the "Coummincating with the OLE server" error occurring. Don't you just love 'inconsistency' ? JT