So I started with the Access contact database template and have been building up from there. There is a functionality in which by clicking on the ID number in the Contact List, it should call up the form to edit the details. I have made no changes to this code, and have even tried recopying it from the template from scratch.
However I am getting the error «A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.» It is telling me to restart the OLE server and try the operation again.
I have an old version of the database saved, and it runs fine over there. It just is something within my code here.
Any guidance would be appreciated.
asked Jul 9, 2015 at 20:11
All of solutions I found online was not working for me.
Found that only rebuilding damaged form from scratch help me to solve this issue.
W10, Office 2016.
answered Feb 13, 2018 at 20:44
DzintarsDzintars
1,43021 silver badges29 bronze badges
I have ran into this error three times in my database. Each time to fix it I simply just open a new blank project and import everything from your old project into your new project.
This might sound like a large undertaking basically you just go into the new project and select «Import Access Database». Then just run through the wizard selecting everything in your current database. Click okay and let it run for a few minutes.
This has fixed it for me every time I have run into your error. I suspect it is just something to do with corruption.
answered Jul 10, 2015 at 12:15
NewdNewd
2,1742 gold badges17 silver badges31 bronze badges
My programs also run into this error sometimes.
I have recently noticed that the error most often occurs on UNBOUND forms (forms without a RECORDSOURCE).
What I have done most recently for these forms is the following:
- Add «some» table (I usually take a Config table with just one record) as the RecordSource.
- Compile the program code (this usually goes well, even before the fix!).
- Save the form
- Open the form. This should work fine now!
- Remove the form’s RecordSource, recompile and save again.
- The form should still work fine!
answered Dec 17, 2018 at 12:50
- Remove From My Forums
-
Общие обсуждения
-
Здравствуйте!
Проблема вот в чем. Я создала базу в Accesse. Нарисовала отчеты. При экспорте этих отчетов в Excel (через связь с Office) у меня выходит ошибка: Приложение MS Access не может запустить сервер OLE. Попытка использовать форму или режим таблицы, содержащие объект OLE, сервер OLE которого не было правильно зарегистрировано. Переустановите сервер OLE.
Office 2003
Предпринятые шаги:::::
1. В начале переустанавливала Office. С 2000 на 2003.
2. Реестр чистила (и OLE в том числе).
3. Перерегистрацию dll файлов запускала
4. Операционку даже переустанавливала.
Ничего не помогло.
Что можете посоветовать?
Заранее спасибо
-
Изменен тип
16 мая 2013 г. 13:08
-
Изменен тип
Seems like this is has been asked a few times before.
After working on a form for a few weeks, I suddenly get the error when I click on a button: «The expression On Click you entered as the event property produced the following error: A problem occurred while Microsoft Access was communicating with the OLE Server or Active X Control.»
This also happens with any control’s event on the form (e.g. After Update on other text fields)
I tried re-installing Access to no avail.
Not sure if this is relevant, but I have a subform on the form as well. I have an «on-click» event that works on the subform, but when the code breaks at the following line (which worked before):
Me.Parent.orderID = Null
The error I get is: «Method ‘Parent’ of object ‘_Form_frmOrderQuery’ failed
(frmOrderQuery is the name of the subform)
Anyway, this all worked before until I changed the query for the subform by adding a few more fields.
Finally: All of the event handlers (button click, after-update, etc) work on my other forms in the database.
Any help/suggestions would be greatly appreciated.
Thanks,
jeff
I am writing a database and cannot find the cause of an error.
The main form is called fContacts and on it there are a number of tabs containing different subforms. One subform called fDonations works perfectly, but the last one I added fGrantApplications does not. As soon as I type an entry into the subform, I get an error
‘A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
Close the OLE server and restart it outside Microsoft Access. Then try the original operation again’.
Once I have cleared this error, i can continue to fill data into the subform, but as soon as I move off the subform I get another error
«You cannot add or change a record because a related record is required in table ‘Contacts'»
The form fContacts has a a primary key contactid and the subforms have a foreign keys contactid which is linked in both cases. I cannot see why one subform should work, but not the other.
I am showing the contactid in a textbox on each subform and whereas the fDonations one changes when I move to another record in the main form, the one on the GrantApplication subform does not. I have had this problem for about a week now and am making no progress
HELP!!
You may receive an error when you open Microsoft Access.
Microsoft Access can’t start the OLE Server.
You tried to use a form, report, or datasheet that contains an OLE object, but the OLE server (the application used to create the object) may not be registered properly. Reinstall the OLE server to register it correctly.
Possible Solutions:
*Start Word or Excel to complete its installation before you use the ‘Publish It with Microsoft Word’ or the ‘Analyze It with Microsoft Excel’ feature in Access 2002.
*In Excel, to to Tools -> Options -> General -> Settings and enable Ignore Other Applications.
*Make sure you specify a full path and file name when doing this in a Macro under Output File.
* Please use the comment form below. Comments are moderated.*