Ошибка microsoft access с ole сервером

Я босюь, что причина намного банальней, но при этом и глобальней.

В ваших таблицах ужасные, невозможные имена полей с пробелами и запятыми и нестандартными буквами. Думаю, просто интерпретатор макросов на этом захлебывается.

Дисклеймер: слово «ужасные» относится к пробелам и запятым, а не к нестандартным буквам. В буквах я ничего плохого не вижу (чего не могу сказать о макросах — в них я не вижу ничего хорошего).

Во всяком случае, я уже сталкивалась с проблемами именно у макросов с именами полей, в которых были русская буква ы, украинские буквы ї, і, є и г с хвостиком вверх (у меня ее нет в раскладке). Код vba работает, а макросы глючат.

Переназовите все ваши латиницей. Без пробелов, без запятых, вообще без никаких знаков кроме подчеркивания. То, как называются поля сейчас — перенесите в свойство «подпись».

Источник

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

Источник

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

trc46's user avatar

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

Dzintars's user avatar

DzintarsDzintars

1,36020 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

Newd's user avatar

NewdNewd

2,1762 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:

  1. Add «some» table (I usually take a Config table with just one record) as the RecordSource.
  2. Compile the program code (this usually goes well, even before the fix!).
  3. Save the form
  4. Open the form. This should work fine now!
  5. Remove the form’s RecordSource, recompile and save again.
  6. The form should still work fine!

Tushar Walzade's user avatar

answered Dec 17, 2018 at 12:50

Rob van Lint's user avatar

Источник
  • Remove From My Forums

  • Вопрос

  • Здравствуйте.. Не могу вставить диаграммы в access, при попытке вставки, выдает сообщение «Не зарегистрирован OLE сервер» С заголовком «Создание Диаграммы» и текстом «Запускаемая процедура Visual Basic содержит недопустимое значение класса для CreateObject», при нажатии на кнопку «ОК», выходит сообщение с заголовком «Microsoft Office Access» и текстом «Сервер OLE не был зарегистрирован, переустановите его для регистрации».. Как можно решить данную проблему? Пробовал уже полностью переустанавливать Microsoft Office, больш ниче )

Ответы

  • Во время установки майкрософи офис выбрала ВОССТАНОВИТЬ и все заработало )))

    • Помечено в качестве ответа

      9 марта 2010 г. 10:43

Источник
  • Remove From My Forums

  • Question

  • Hi,

    I am importing Excel 2007 file into SqlServer 2005 (Sqlexpress). The office 2007 is not installed in the machine. I have downloaded and installed «AccessDatabaseEngine». When I execute following statement

    SELECT * FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0’, ‘Excel 12.0;Database=D:File1.xlsx’, ‘SELECT * FROM [Sheet1$]’);The following error is comming:

    Msg 7399, Level 16, State 1, Line 1
    The OLE DB provider «Microsoft.ACE.OLEDB.12.0» for linked server «(null)» reported an error. Access denied.
    Msg 7350, Level 16, State 2, Line 1
    Cannot get the column information from OLE DB provider «Microsoft.ACE.OLEDB.12.0» for linked server «(null)».Can any one suggest what should I do to resolve?

    Thanks,
    Parmeshthee.

    Learning .Net 3.5

Answers

  • Try run this:

    USE [master]
    GO

    EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’AllowInProcess’ , 1
    GO

    EXEC master . dbo. sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’DynamicParameters’ , 1
    GO

     Then try your query. I have met this issue before and this should works.

    • Proposed as answer by

      Wednesday, July 22, 2009 8:26 AM

    • Marked as answer by
      Ying Lin — MSFT
      Friday, August 7, 2009 1:13 AM

  • Hi

    After reading registry entries for other providers, I have added a new entry to registry and it’s working fine now Windows 7 32 bit. It seems that Microsoft does not want to populate ACE OLEDB provider.

    Create a .reg file with text below and replace MSSQL10 (10 = SQL Server 2008) with your MSSQL version and SQLADV with SQL Server instance name. Save the file and run. It’ll add this entry to registry and you can use OPENROWSET with ACE OLEDB providers.

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.SQLADVProvidersMicrosoft.ACE.OLEDB.12.0]
    «AllowInProcess»=dword:00000001

    • Marked as answer by
      Ying Lin — MSFT
      Friday, August 7, 2009 1:13 AM

Источник

Понравилась статья? Поделить с друзьями:
  • Ошибка mfc140u dll при запуске приложения coreldraw
  • Ошибка microsoft visual basic for application
  • Ошибка metro 2033 applications load error 5 0000065434
  • Ошибка microsoft store код 0x803fb005
  • Ошибка messages file c program files