Содержание
- Microsoft Office Access: «Ошибка при загрузке библиотеки DLL»
- Симптомы
- Причина
- ACEDAO.DLL
- Установки MSI
- Установка «нажми и запускай»
- DAO360.DLL
- Решение
- Самостоятельное решение проблемы
- Дополнительная информация
- «Error in loading DLL» error when you run a Microsoft Access wizard
- Symptoms
- Cause
- Resolution
- Error in loading dll access 2007
- Asked by:
- Question
- All replies
- Microsoft Office Access: ‘Error in loading dll’
- Symptoms
- Cause
- ACEDAO.DLL
- MSI installations
- Click-to-Run installations
- DAO360.DLL
- Resolution
- Let me fix it myself
- More Information
Microsoft Office Access: «Ошибка при загрузке библиотеки DLL»
Симптомы
При попытке запуска мастеров в Microsoft Office Access, таких как мастера импорта, мастер запросов, мастер отчетов и мастера управления, возникает одна из следующих ошибок:
«Ошибка при загрузке библиотеки DLL»
«Библиотека объектов не зарегистрирована»
Причина
Один из следующих разделов реестра может не существовать.
ACEDAO.DLL
Установки MSI
(64-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
Строка: (по умолчанию)
Значение: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(64-разрядная версия Windows, 64-разрядная версия Office):
Раздел: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win64
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(32-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
Office14 используется в описанном выше пути раздела реестра. Он должен представлять текущую установленную версию Access.
- OFFICE12 — Access 2007
- OFFICE14 — Access 2010
- OFFICE15 — Access 2013
- OFFICE16 — Access 2016
Установка «нажми и запускай»
(64-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
Строка: (по умолчанию)
Значение: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(64-разрядная версия Windows, 64-разрядная версия Office):
Раздел: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win64
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(32-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
DAO360.DLL
(64-разрядная версия Windows, 32-разрядная версия Office)
Раздел: HKEY_CLASSES_ROOTTYPELIB<00025e01-0000-0000-c000-000000000046>5.0win32
Строка: (по умолчанию)
Значение: %CommonProgramFiles(x86)%Microsoft SharedDAOdao360.dll
(64-разрядная версия Windows, 64-разрядная версия Office) или (32-разрядная версия Windows, 32-разрядная версия Office)
Раздел: HKEY_CLASSES_ROOTTYPELIB<00025e01-0000-0000-c000-000000000046>5.0win32
Строка: (по умолчанию)
Значение: %CommonProgramFiles%Microsoft SharedDAOdao360.dll
Решение
Чтобы устранить проблему с установкой MSI, задав правильные значения для этих библиотек DLL в реестре, перейдите к разделу «Позвольте мне исправить его самостоятельно «. Чтобы устранить проблему с установкой Office «нажми и запускай», выполните оперативное восстановление установки Office. Дополнительные сведения о восстановлении см. в разделе «Восстановление приложения Office».
Самостоятельное решение проблемы
Приведенные ниже действия устраняют проблему, за задание правильных значений для этих библиотек DLL в реестре.
При неправильном изменении реестра с использованием редактора реестра или другого способа могут случиться серьезные проблемы. Для решения этих проблем может потребоваться переустановка операционной системы. Компания Microsoft не может гарантировать, что эти проблемы могут быть решены. Вносите изменения в реестр на ваш страх и риск.
Действия по повторному воссоздание ключей для установок MSI:
Скопируйте и вставьте следующие строки текста для своей среды, начиная с редактора реестра Windows версии 5.00, в документ Блокнота:
(64-разрядная версия Windows, 32-разрядная версия Office):
(64-разрядная версия Windows, 64-разрядная версия Office):
(32-разрядная версия Windows, 32-разрядная версия Office):
Убедитесь, что версия Office (OFFICE14), указанная в пути, соответствует соответствующему значению из списка в начале этой статьи.
Сохраните файл Блокнота как Win32Keys.reg.
Выполните одно из следующих действий.
- В проводнике Windows дважды щелкните файл Win32Keys.reg, чтобы запустить его.
- В редакторе реестра перейдите к разделу «Импорт файлов», > чтобы перейти к сохраненному файлу Win32Keys.reg, а затем нажмите кнопку «Открыть».
Дополнительная информация
Средства очистки реестра не удаляют ключ HKEY_CLASSES_ROOTTYPELIB<00025e01-0000-0000-c000-000000000046>5.0win32 в 32-разрядных версиях Windows. Однако если возникает ошибка «Ошибка загрузки DLL», возможно, dao360.dll msado15.dll установлена программа, которая неправильно зарегистрирована либо .
Источник
«Error in loading DLL» error when you run a Microsoft Access wizard
Original KB number: В 833220
This article applies only to a Microsoft Access database (.mdb). Requires basic macro, coding, and interoperability skills.
Symptoms
When you try to use a Microsoft Access wizard, such as the Import Text wizard or the Import Spreadsheet wizard, in Microsoft Access 2002, you may receive the following error message. When you try to open a form that is created by the Switchboard manager, you may receive the following error message:
Cause
This problem may occur if you have missing Microsoft Data Access Components (MDAC) files, corrupted MDAC files, or outdated MDAC files on your computer.
Resolution
To resolve this problem, use either of the following methods:
Method 1: Register the required Dao360.dll file and the Msado15.dll file
You may have to register the Dao360.dll file and the Msado15.dll file by using the Regsvr32.exe program. To do this, follow these steps:
Click Start, and then click Run.
In the Run dialog box, type the following commands in the Open box, and then click OK:
The Dao360.dll_Path placeholder is the absolute path of the Dao360.dll file.
The Msado15.dll_Path placeholder is the absolute path of the Msado15.dll file.
The following examples show how you may specify an absolute path:
Regsvr32.exe «C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll»
Regsvr32.exe «C:Program FilesCommon FilessystemadoMsado15.dll»
If the Dao360.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll succeeded.
If the Msado15.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilessystemadoMsado15.dll succeeded.
Click OK.
Method 2: Install the latest version of MDAC
For additional information about how to download the latest version of MDAC, visit the following Microsoft Developer Network (MSDN) Web site:
Источник
Error in loading dll access 2007
This forum is closed. Thank you for your contributions.
Asked by:
Question
To anyone that can help,
I am recieving multiple error messages «error in loading DLL» when trying to run the «Form Wizard» in Access 2007. Ultimately the form wont load correctly. In addition the message has been showing up periodically while completing other tasks as well, but the task completes. But with the Wizard it will not. Any help with this would be appreciated.
Currently running Win7 64bit
I have had this post up for 19hrs with no response is it possible I am in the wrong forum for this??
Any help would be appreciated.
This problem may occur if you have missing Microsoft Data Access Components (MDAC) files, corrupted MDAC files, or outdated MDAC files on your computer.
To resolve this problem, use either of the following methods:
Method 1: Register the required Dao360.dll file and the Msado15.dll file
You may have to register the Dao360.dll file and the Msado15.dll file by using the Regsvr32.exe program. To do this, follow these steps:
- Click Start, and then click Run.
- In the Run dialog box, type the following commands in the Open box, and then click OK:
The > placeholder is the absolute path of the Dao360.dll file.
The > placeholder is the absolute path of the Msado15.dll file.
The following examples show how you may specify an absolute path:
Regsvr32.exe «C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll»
Regsvr32.exe «C:Program FilesCommon FilessystemadoMsado15.dll»
If the Dao360.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll succeeded.
If the Msado15.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilessystemadoMsado15.dll succeeded.
Method 2: Install the latest version of MDAC
For additional information about how to download the latest version of MDAC, visit the following Microsoft Developer Network (MSDN) Web site:
For more information about this issue, please refer to the link:
Источник
Microsoft Office Access: ‘Error in loading dll’
Symptoms
When trying to run wizards in Microsoft Office Access, such as the Import Wizards, the Query Wizard, the Report Wizard, and Control Wizards, you receive one of the following errors:
Cause
One of the following registry keys may not exist.
ACEDAO.DLL
MSI installations
(64-bit Windows, 32-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win64
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
OFFICE14 is used in the above registry key path. This should represent the current version of Access installed.
- OFFICE12 — Access 2007
- OFFICE14 — Access 2010
- OFFICE15 — Access 2013
- OFFICE16 — Access 2016
Click-to-Run installations
(64-bit Windows, 32-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win64
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
DAO360.DLL
(64-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles(x86)%Microsoft SharedDAOdao360.dll
(64-bit Windows, 64-bit Office) or (32-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles%Microsoft SharedDAOdao360.dll
Resolution
To resolve the issue for MSI installations by setting the correct values for these dlls in the registry , go to the Let me fix it myself section. To resolve the issue for Click-to-Run installations of Office, perform an online repair to the Office installation. For more information about how to repair, see Repair an Office application.
Let me fix it myself
The steps below resolve the issue by setting the correct values for these dlls in the registry.
Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
Steps to recreate the keys for MSI Installations:
Copy and paste the following lines of text for your environment, starting with ‘Windows Registry Editor Version 5.00’, into the Notepad document:
(64-bit Windows, 32-bit Office):
(64-bit Windows, 64-bit Office):
(32-bit Windows, 32-bit Office):
Ensure the office version (OFFICE14) specified in the path matches the appropriate value from the list at the beginning of this article.
Save the Notepad file as Win32Keys.reg.
Do one of the following:
- Using Windows Explorer, double-click on the Win32Keys.reg file to run it.
- In the registry editor, go to File >Import to browse to where you saved the Win32Keys.reg file, and then click Open.
More Information
Registry cleaners are not known to remove the HKEY_CLASSES_ROOTTYPELIB<00025e01-0000-0000-c000-000000000046>5.0win32 key on 32-bit versions of Windows. However, if you experience the ‘Error loading dll’ error, you may have installed a program that misregistered either dao360.dll or msado15.dll .
Источник
|
0 / 0 / 0 Регистрация: 18.01.2014 Сообщений: 99 |
|
|
1 |
|
|
13.05.2015, 22:18. Показов 17290. Ответов 4
Прошу помощи! Есть (или был) длинный код, который с большим скрипом писал несколько недель. Сейчас открываю документ, а мне Excel выдает ошибку «Error in loading DLL», а лист, на котором было многобукв абсолютно пустой! Копию книги не делал. Есть шанс восстановить код????
__________________
0 |
|
6076 / 1320 / 195 Регистрация: 12.12.2012 Сообщений: 1,023 |
|
|
14.05.2015, 11:51 |
2 |
Вам может помочь следующая последовательность действий:
Рекомендации взяты с одного англоязычного форума и переведены на русский. Еще там есть ряд полезных замечаний по поводу вышеприведенных рекомендаций: Замечание первое: перед удалением ссылок, возможно, понадобится также удалить все элементы управления форм, которые используют битые библиотеки. С уважением,
2 |
|
0 / 0 / 0 Регистрация: 18.01.2014 Сообщений: 99 |
|
|
14.05.2015, 22:18 [ТС] |
3 |
|
Аксима, спасибо за ответ. Действительно оказалась проблема с несовместимостью библиотек. Компьютер с офисом 2007 отказывается открывать программу, сделанную в 2003 офисе. Отключение отсутствующих библиотек тоже не помогает. Утром на рабочем компьютере все открылось как ни в чем ни бывало. Можно ли набор всех необходимых библиотек прикрутить к самому файлу эксель, чтобы он по умолчанию был совместим с любым компьютером?
0 |
|
6076 / 1320 / 195 Регистрация: 12.12.2012 Сообщений: 1,023 |
|
|
15.05.2015, 09:47 |
4 |
|
какие библиотеки Те библиотеки, которые помечены как отсутствующие на проблемном компьютере.
откуда мне нужно забрать На рабочем компьютере посмотрите поле Location в меню Tools->References.
И так же для других отсутствующих библиотек.
Можно ли набор всех необходимых библиотек прикрутить к самому файлу эксель Сомневаюсь. Файл Excel не является исполняемым файлом, его нельзя скомпилировать вместе с нужными библиотеками.
1 |
|
Модератор 8979 / 3327 / 849 Регистрация: 22.02.2013 Сообщений: 5,012 Записей в блоге: 78 |
|
|
15.05.2015, 17:01 |
5 |
|
Можно ли набор всех необходимых библиотек прикрутить к самому файлу эксель, чтобы он по умолчанию был совместим с любым компьютером? Можно это сделать несколькими способами просто хранив бинарные данные в нужном виде. Например в Base64 или как внедренный объект, после распаковывать и использовать.
0 |
- Remove From My Forums
-
Question
-
To anyone that can help,
I am recieving multiple error messages «error in loading DLL» when trying to run the «Form Wizard» in Access 2007. Ultimately the form wont load correctly. In addition the message has been showing up periodically while completing other tasks as
well, but the task completes. But with the Wizard it will not. Any help with this would be appreciated.Currently running Win7 64bit
Thanks,
G.E. Bewick
I have had this post up for 19hrs with no response is it possible I am in the wrong forum for this??
Any help would be appreciated!!!
-
Edited by
Thursday, May 3, 2012 7:27 PM
-
Edited by
Microsoft Office Access: «Ошибка при загрузке библиотеки DLL»
Симптомы
При попытке запуска мастеров в Microsoft Office Access, таких как мастера импорта, мастер запросов, мастер отчетов и мастера управления, возникает одна из следующих ошибок:
«Ошибка при загрузке библиотеки DLL»
«Библиотека объектов не зарегистрирована»
Причина
Один из следующих разделов реестра может не существовать.
ACEDAO.DLL
Установки MSI
(64-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_CLASSES_ROOT TypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
Строка: (по умолчанию)
Значение: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(64-разрядная версия Windows, 64-разрядная версия Office):
Раздел: HKEY_CLASSES_ROOT TypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win64
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(32-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_CLASSES_ROOT TypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
Office14 используется в описанном выше пути раздела реестра. Он должен представлять текущую установленную версию Access.
- OFFICE12 — Access 2007
- OFFICE14 — Access 2010
- OFFICE15 — Access 2013
- OFFICE16 — Access 2016
Установка «нажми и запускай»
(64-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
Строка: (по умолчанию)
Значение: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(64-разрядная версия Windows, 64-разрядная версия Office):
Раздел: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win64
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(32-разрядная версия Windows, 32-разрядная версия Office):
Раздел: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
Строка: (по умолчанию)
Значение: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
DAO360.DLL
(64-разрядная версия Windows, 32-разрядная версия Office)
Раздел: HKEY_CLASSES_ROOTTYPELIB<00025E01-0000-0000-C000-000000000046>5.0win32
Строка: (по умолчанию)
Значение: %CommonProgramFiles(x86)%Microsoft SharedDAOdao360.dll
(64-разрядная версия Windows, 64-разрядная версия Office) или (32-разрядная версия Windows, 32-разрядная версия Office)
Раздел: HKEY_CLASSES_ROOTTYPELIB<00025E01-0000-0000-C000-000000000046>5.0win32
Строка: (по умолчанию)
Значение: %CommonProgramFiles%Microsoft SharedDAOdao360.dll
Решение
Чтобы устранить проблему с установкой MSI, задав правильные значения для этих библиотек DLL в реестре, перейдите к разделу «Позвольте мне исправить его самостоятельно «. Чтобы устранить проблему с установкой Office «нажми и запускай», выполните оперативное восстановление установки Office. Дополнительные сведения о восстановлении см. в разделе «Восстановление приложения Office».
Самостоятельное решение проблемы
Приведенные ниже действия устраняют проблему, за задание правильных значений для этих библиотек DLL в реестре.
При неправильном изменении реестра с использованием редактора реестра или другого способа могут случиться серьезные проблемы. Для решения этих проблем может потребоваться переустановка операционной системы. Компания Microsoft не может гарантировать, что эти проблемы могут быть решены. Вносите изменения в реестр на ваш страх и риск.
Действия по повторному воссоздание ключей для установок MSI:
Скопируйте и вставьте следующие строки текста для своей среды, начиная с редактора реестра Windows версии 5.00, в документ Блокнота:
(64-разрядная версия Windows, 32-разрядная версия Office):
(64-разрядная версия Windows, 64-разрядная версия Office):
(32-разрядная версия Windows, 32-разрядная версия Office):
Убедитесь, что версия Office (OFFICE14), указанная в пути, соответствует соответствующему значению из списка в начале этой статьи.
Сохраните файл Блокнота как Win32Keys.reg.
Выполните одно из следующих действий.
- В проводнике Windows дважды щелкните файл Win32Keys.reg, чтобы запустить его.
- В редакторе реестра перейдите к разделу «Импорт файлов», > чтобы перейти к сохраненному файлу Win32Keys.reg, а затем нажмите кнопку «Открыть».
Дополнительная информация
Средства очистки реестра не удаляют ключ HKEY_CLASSES_ROOTTYPELIB<00025E01-0000-0000-C000-000000000046>5.0win32 в 32-разрядных версиях Windows. Однако если возникает ошибка «Ошибка загрузки DLL», возможно, dao360.dll msado15.dll установлена программа, которая неправильно зарегистрирована либо .
Источник
Ошибка «Ошибка при загрузке библиотеки DLL» при запуске мастера Microsoft Access
Исходный номер базы знаний: 833220
Эта статья относится только к базе данных Microsoft Access (MDB). Требуются базовые навыки работы с кодом, макросами и взаимодействия.
Симптомы
При попытке использовать мастер Microsoft Access, например мастер импорта текста или мастер импорта электронных таблиц, в Microsoft Access 2002 может появиться следующее сообщение об ошибке. При попытке открыть форму, созданную диспетчером switchboard, может появиться следующее сообщение об ошибке:
Ошибка при загрузке библиотеки DLL
Причина
Эта проблема может возникнуть, если на компьютере отсутствуют файлы компонентов доступа к данным (MDAC), поврежденные MDAC-файлы или устаревшие MDAC-файлы.
Решение
Чтобы устранить эту проблему, используйте один из следующих методов:
Метод 1. Регистрация требуемого Dao360.dll и Msado15.dll файла
Возможно, потребуется зарегистрировать Dao360.dll и Msado15.dll с помощью Regsvr32.exe. Для этого выполните следующие действия:
Нажмите кнопку Пуск и выберите пункт Выполнить.
В диалоговом окне «Запуск» введите следующие команды в поле « Открыть» и нажмите кнопку » ОК»:
Заполнитель Dao360.dll_Path является абсолютным путем к Dao360.dll файла.
Заполнитель Msado15.dll_Path является абсолютным путем к Msado15.dll файла.
В следующих примерах показано, как можно указать абсолютный путь:
Regsvr32.exe «C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll»
Regsvr32.exe «C:Program FilesCommon FilessystemadoMsado15.dll»
Если файл Dao360.dll успешно зарегистрирован, вы получите сообщение, аналогичное следующему:
DllRegisterServer в C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll успешно.
Если файл Msado15.dll успешно зарегистрирован, вы получите сообщение, аналогичное следующему:
DllRegisterServer в C:Program FilesCommon FilessystemadoMsado15.dll успешно.
Нажмите кнопку ОК.
Метод 2. Установка последней версии MDAC
Дополнительные сведения о том, как скачать последнюю версию MDAC, см. на следующем веб-сайте Microsoft Developer Network (MSDN):
Источник
«Error in loading DLL» error when you run a Microsoft Access wizard
Original KB number: В 833220
This article applies only to a Microsoft Access database (.mdb). Requires basic macro, coding, and interoperability skills.
Symptoms
When you try to use a Microsoft Access wizard, such as the Import Text wizard or the Import Spreadsheet wizard, in Microsoft Access 2002, you may receive the following error message. When you try to open a form that is created by the Switchboard manager, you may receive the following error message:
Cause
This problem may occur if you have missing Microsoft Data Access Components (MDAC) files, corrupted MDAC files, or outdated MDAC files on your computer.
Resolution
To resolve this problem, use either of the following methods:
Method 1: Register the required Dao360.dll file and the Msado15.dll file
You may have to register the Dao360.dll file and the Msado15.dll file by using the Regsvr32.exe program. To do this, follow these steps:
Click Start, and then click Run.
In the Run dialog box, type the following commands in the Open box, and then click OK:
The Dao360.dll_Path placeholder is the absolute path of the Dao360.dll file.
The Msado15.dll_Path placeholder is the absolute path of the Msado15.dll file.
The following examples show how you may specify an absolute path:
Regsvr32.exe «C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll»
Regsvr32.exe «C:Program FilesCommon FilessystemadoMsado15.dll»
If the Dao360.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll succeeded.
If the Msado15.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilessystemadoMsado15.dll succeeded.
Click OK.
Method 2: Install the latest version of MDAC
For additional information about how to download the latest version of MDAC, visit the following Microsoft Developer Network (MSDN) Web site:
Источник
Microsoft Office Access: ‘Error in loading dll’
Symptoms
When trying to run wizards in Microsoft Office Access, such as the Import Wizards, the Query Wizard, the Report Wizard, and Control Wizards, you receive one of the following errors:
Cause
One of the following registry keys may not exist.
ACEDAO.DLL
MSI installations
(64-bit Windows, 32-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
String: (Default)
Value: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win64
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
OFFICE14 is used in the above registry key path. This should represent the current version of Access installed.
- OFFICE12 — Access 2007
- OFFICE14 — Access 2010
- OFFICE15 — Access 2013
- OFFICE16 — Access 2016
Click-to-Run installations
(64-bit Windows, 32-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
String: (Default)
Value: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win64
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28>c.0win32
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
DAO360.DLL
(64-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles(x86)%Microsoft SharedDAOdao360.dll
(64-bit Windows, 64-bit Office) or (32-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles%Microsoft SharedDAOdao360.dll
Resolution
To resolve the issue for MSI installations by setting the correct values for these dlls in the registry , go to the Let me fix it myself section. To resolve the issue for Click-to-Run installations of Office, perform an online repair to the Office installation. For more information about how to repair, see Repair an Office application.
Let me fix it myself
The steps below resolve the issue by setting the correct values for these dlls in the registry.
Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
Steps to recreate the keys for MSI Installations:
Copy and paste the following lines of text for your environment, starting with ‘Windows Registry Editor Version 5.00’, into the Notepad document:
(64-bit Windows, 32-bit Office):
(64-bit Windows, 64-bit Office):
(32-bit Windows, 32-bit Office):
Ensure the office version (OFFICE14) specified in the path matches the appropriate value from the list at the beginning of this article.
Save the Notepad file as Win32Keys.reg.
Do one of the following:
- Using Windows Explorer, double-click on the Win32Keys.reg file to run it.
- In the registry editor, go to File >Import to browse to where you saved the Win32Keys.reg file, and then click Open.
More Information
Registry cleaners are not known to remove the HKEY_CLASSES_ROOTTYPELIB<00025E01-0000-0000-C000-000000000046>5.0win32 key on 32-bit versions of Windows. However, if you experience the ‘Error loading dll’ error, you may have installed a program that misregistered either dao360.dll or msado15.dll .
Источник
by Matthew Adams
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things… read more
Updated on October 10, 2022
- The Microsoft Office Access error in loading DLL usually occurs when users try to import text or spreadsheets into a wizard.
- This issue can be easily fixed by installing a third-party software tool that can fix DLL files.
- If you’re getting the DLL loading error on MS Access, make sure you have the latest MDAC version.
- Follow our method below to ensure that you’ve registered all the necessary files.
MS Office’s Access is among the foremost database applications that millions of users utilize to set up databases, and for a reason. The app is great and filled with a wide variety of features.
However, some Access users have encountered an Error in loading DLL message when they try to run wizards within the software, which makes it hard for them to use the software.
Thus, the error can arise when users try to import text or spreadsheets with the required wizards. The Error in loading DLL error can crash the active Access window.
How do I fix the DLL loading error in Microsoft Access?
1. Use a third-party DLL fixer
Restoro is a premium software that will restore any faulty or compromised files on your PC, including DLL files and crucial system data as well.
Besides restoring your PC and keeping it clean, the program will also improve its performance and keep any malfware and adware away while browsing the internet.
Restoro is a reliable third-party DLL fixer which uses a built-in automated system and an online library full of functional DLLs to replace and repair any files that might be corrupted or damaged on your PC.
All you need to do to resolve your PC’s problems is to launch it, and simply follow the on-screen instructions to start the process, as everything else is covered by the software’s automated processes.
This is how you can fix registry errors using Restoro:
- Download and install Restoro.
- Launch the software.
- Wait for it to scan your PC for any stability issues and possible malware.
- Press Start Repair.
- Restart your PC for all the changes to take effect.
After this process is completed your PC will be as good as new, and you will no longer have to deal with BSoD errors, slow response times, or other similar issues.
⇒ Get Restoro
Disclaimer: This program needs to be upgraded from the free version in order to perform some specific actions.
2. Register the Dao360 and Msado15 DLL files
- The official Microsoft resolution for the Error in loading DLL error is to register the Dao360 and Msado15 DLL files. To do so, open the Win + X menu with the Windows key + X hotkey.
- Select Run to open that accessory.
- Search for the following in the Run’s text box then select Ok:
Regsvr32.exeC:ProgramFilesCommonFilesMicrosoftSharedDAODao360.dll
- Then in Run, input the following and select Ok:
Regsvr32.exeC:ProgramFilesCommonFilessystemadoMsado15.dll
3. Install the latest MDAC Version
- Go to the MDAC page.
- Download the MDAC installer from the page.
- Run the program on your PC.
- Follow the installation process.
- That’s it. You’ve successfully updated MDAC.
Some PC issues are hard to tackle, especially when it comes to corrupted repositories or missing Windows files. If you are having troubles fixing an error, your system may be partially broken.
We recommend installing Restoro, a tool that will scan your machine and identify what the fault is.
Click here to download and start repairing.
Some users might need to update MDAC to fix the Error in loading DLL error. Once you’ve updated it, it is advised to restart your device.
Note: The software hasn’t been updated but it still works as intended, so you shouldn’t care much about it being discontinued. The latest version is 2.8.
4. Repair MS Office from the Programs and Features Applet
- Launch Run by pressing the Windows key + R keyboard shortcut.
- To open Windows’ uninstaller, enter appwiz.cpl in the text box.
- Then select the OK.
- Select the MS Office suite listed within the Programs and Features Control Panel applet.
- Then select the Change option.
- Thereafter, an MS Office dialog box window will open that includes a Repair option. Select it, and click the Continue button.
- MS Office 2016 users can select an Online Repair option to fix the suite’s applications.
- Thereafter, click Close when the repair, or configuration, the process is finished.
Note: Some users have confirmed they’ve fixed the Error in loading DLL error by selecting the Change option for MS Office on the Control Panel’s uninstaller applet.
5. Fix Access Files with the Access Repair Tool
- Click the Free Download Access Repair Tool button on the Access Repair Tool page to save the installer for that software.
- Open the installer Stellar Repair for Access installer to add the software to Windows.
- After opening the software, click the Browse button to select a file to repair.
- Then press the Repair button.
- Thereafter, the software displays a preview of the displayed file. Click Save Database to select a path to save file at.
If the Error in loading DLL arises for a more specific Access database file, try fixing it with Stellar Repair for Access, which has a demo version that users can try out.
Those are some of the more probable fixes for the error in loading DLL on Microsoft Access. With that error fixed, Access users can then utilize the application’s wizards for their databases.
Still having issues? Fix them with this tool:
SPONSORED
If the advices above haven’t solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.
Newsletter
I am trying to run the label wizard in Microsoft Access 2007, but when I click on Create → Labels, I get this error message:
Dennis
48.2k11 gold badges129 silver badges148 bronze badges
asked Sep 3, 2011 at 14:00
3
The usual first step in troubleshooting a problem like this (i.e., the functionality of an Office program is not working) is to run the REPAIR function on Office from the ADD/REMOVE PROGRAMS tool in Control Panel.
answered Sep 13, 2011 at 0:25
It appears that the solution was running a ‘repair’ solved the problem:
- Control Panel
- Uninstall a Program
- Select your office suite
- Select «Change»:
XP
WIN7
Run through the setup process BUT SELECT REPAIR instead.
For Office 2007 it looks like this:
For Office 2010 it looks like this:
If this doesn’t work, then you can also try uninstalling and re-installing the program.
answered Sep 12, 2011 at 18:17
James MertzJames Mertz
26k41 gold badges108 silver badges163 bronze badges
Try this one also:
- Click the Microsoft Office button, and then click «Access Options»
- In the «Access Options» dialog box, click «Current Database»
- Under «Application Options», select the «Compact on Close» check box
Indrek
23.9k14 gold badges89 silver badges93 bronze badges
answered Jan 22, 2013 at 20:41
Hello,
I am getting an error message when calling the DAO.RecordSet.Fields property.
The error message shown on the call to the property is «Error in loading DLL(48)». Following is a VB6 code snippet which returns the error.
Sub Main()
Dim str As String
Dim DB As DAO.Database
Dim DT As DAO.TableDef
Dim RS As DAO.Recordset
Dim lineNo As Long
Dim s$
Dim nFileNo As Long
Dim Fld As DAO.Field
Dim FldVal As Variant
16: LogMsg «<Main>» ‘zacra01
17: str = Command()
On Error GoTo MDBOpenError
18: nFileNo = FreeFile
19: Open str For Input Access Read As #nFileNo
20: Close #nFileNo
On Error GoTo DBError
21: Set DB = OpenDatabase(str, False, True)
22: Set RS = DB.OpenRecordset(«SELECT * FROM [+Maintenance]»)
23: RS.MoveFirst
24: LogMsg «<Query =» & RS.Name & «>»
25: s$ = «»
MsgBox «Before RS.Fields»
26: For Each Fld In RS.Fields
MsgBox «After RS.Fields»
27: s$ = s$ & Fld.Name & VBA.vbTab
28: Next
29: LogMsg s$ & VBA.vbNewLine &
….
The code line causing the error is marked with label «26:» (below):
…
26: For Each Fld In RS.Fields
…
This error occurs only on a single computer. Other computers execute this code line well. On the other computers, I can see in SysInternals’ Process Explorer that right after successful execution of the line 26:, library DAO360.DLL gets loaded into the application
process for the second time . That is why I suspect the error message «Error in loading DLL» says it failed to load DAO360.DLL for the second time.
Can you think of a reason why the call to the Fields property fails to load DAO360.DLL for the second time on the particular computer while it succeeds on others?
Thank you,
Radovan
Содержание
- «Error in loading DLL» error when you run a Microsoft Access wizard
- Symptoms
- Cause
- Resolution
- Microsoft Office Access: ‘Error in loading dll’
- Symptoms
- Cause
- ACEDAO.DLL
- MSI installations
- Click-to-Run installations
- DAO360.DLL
- Resolution
- Let me fix it myself
- More Information
- Microsoft access dll error
- Answered by:
- Question
- Answers
- All replies
- FIX: Microsoft Office Access error in loading DLL
- How do I fix the DLL loading error in Microsoft Access?
- 1. Use a third-party DLL fixer
- 2. Register the Dao360 and Msado15 DLL files
- 3. Install the latest MDAC Version
- 4. Repair MS Office from the Programs and Features Applet
- 5. Fix Access Files with the Access Repair Tool
«Error in loading DLL» error when you run a Microsoft Access wizard
Original KB number: В 833220
This article applies only to a Microsoft Access database (.mdb). Requires basic macro, coding, and interoperability skills.
Symptoms
When you try to use a Microsoft Access wizard, such as the Import Text wizard or the Import Spreadsheet wizard, in Microsoft Access 2002, you may receive the following error message. When you try to open a form that is created by the Switchboard manager, you may receive the following error message:
Cause
This problem may occur if you have missing Microsoft Data Access Components (MDAC) files, corrupted MDAC files, or outdated MDAC files on your computer.
Resolution
To resolve this problem, use either of the following methods:
Method 1: Register the required Dao360.dll file and the Msado15.dll file
You may have to register the Dao360.dll file and the Msado15.dll file by using the Regsvr32.exe program. To do this, follow these steps:
Click Start, and then click Run.
In the Run dialog box, type the following commands in the Open box, and then click OK:
The Dao360.dll_Path placeholder is the absolute path of the Dao360.dll file.
The Msado15.dll_Path placeholder is the absolute path of the Msado15.dll file.
The following examples show how you may specify an absolute path:
Regsvr32.exe «C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll»
Regsvr32.exe «C:Program FilesCommon FilessystemadoMsado15.dll»
If the Dao360.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilesMicrosoft SharedDAODao360.dll succeeded.
If the Msado15.dll file is successfully registered, you receive a message that is similar to the following message:
DllRegisterServer in C:Program FilesCommon FilessystemadoMsado15.dll succeeded.
Click OK.
Method 2: Install the latest version of MDAC
For additional information about how to download the latest version of MDAC, visit the following Microsoft Developer Network (MSDN) Web site:
Источник
Microsoft Office Access: ‘Error in loading dll’
Symptoms
When trying to run wizards in Microsoft Office Access, such as the Import Wizards, the Query Wizard, the Report Wizard, and Control Wizards, you receive one of the following errors:
Cause
One of the following registry keys may not exist.
ACEDAO.DLL
MSI installations
(64-bit Windows, 32-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win64
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_CLASSES_ROOT TypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE14ACEDAO.DLL
OFFICE14 is used in the above registry key path. This should represent the current version of Access installed.
- OFFICE12 — Access 2007
- OFFICE14 — Access 2010
- OFFICE15 — Access 2013
- OFFICE16 — Access 2016
Click-to-Run installations
(64-bit Windows, 32-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program Files (x86)Common FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win64
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice15.0ClickToRunREGISTRYMACHINESOFTWAREClassesTypeLib<4ac9e1da-5bad-4ac7-86e3-24f4cdceca28>c.0win32
String: (Default)
Value: C:Program FilesCommon FilesMicrosoft SharedOFFICE16ACEDAO.DLL
DAO360.DLL
(64-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles(x86)%Microsoft SharedDAOdao360.dll
(64-bit Windows, 64-bit Office) or (32-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles%Microsoft SharedDAOdao360.dll
Resolution
To resolve the issue for MSI installations by setting the correct values for these dlls in the registry , go to the Let me fix it myself section. To resolve the issue for Click-to-Run installations of Office, perform an online repair to the Office installation. For more information about how to repair, see Repair an Office application.
Let me fix it myself
The steps below resolve the issue by setting the correct values for these dlls in the registry.
Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
Steps to recreate the keys for MSI Installations:
Copy and paste the following lines of text for your environment, starting with ‘Windows Registry Editor Version 5.00’, into the Notepad document:
(64-bit Windows, 32-bit Office):
(64-bit Windows, 64-bit Office):
(32-bit Windows, 32-bit Office):
Ensure the office version (OFFICE14) specified in the path matches the appropriate value from the list at the beginning of this article.
Save the Notepad file as Win32Keys.reg.
Do one of the following:
- Using Windows Explorer, double-click on the Win32Keys.reg file to run it.
- In the registry editor, go to File >Import to browse to where you saved the Win32Keys.reg file, and then click Open.
More Information
Registry cleaners are not known to remove the HKEY_CLASSES_ROOTTYPELIB<00025e01-0000-0000-c000-000000000046>5.0win32 key on 32-bit versions of Windows. However, if you experience the ‘Error loading dll’ error, you may have installed a program that misregistered either dao360.dll or msado15.dll .
Источник
Microsoft access dll error
This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Answered by:
Question
Hello,
I am getting an error message when calling the DAO.RecordSet.Fields property.
The error message shown on the call to the property is «Error in loading DLL(48)». Following is a VB6 code snippet which returns the error.
Dim str As String
Dim DB As DAO.Database
Dim DT As DAO.TableDef
Dim RS As DAO.Recordset
Dim lineNo As Long
Dim s$
Dim nFileNo As Long
Dim Fld As DAO.Field
Dim FldVal As Variant
16: LogMsg » » ‘zacra01
17: str = Command()
On Error GoTo MDBOpenError
18: nFileNo = FreeFile
19: Open str For Input Access Read As #nFileNo
20: Close #nFileNo
On Error GoTo DBError
21: Set DB = OpenDatabase(str, False, True)
22: Set RS = DB.OpenRecordset(«SELECT * FROM [+Maintenance]»)
23: RS.MoveFirst
24: LogMsg » »
25: s$ = «»
MsgBox «Before RS.Fields»
26: For Each Fld In RS.Fields
MsgBox «After RS.Fields»
27: s$ = s$ & Fld.Name & VBA.vbTab
28: Next
29: LogMsg s$ & VBA.vbNewLine &
.
The code line causing the error is marked with label «26:» (below):
.
26: For Each Fld In RS.Fields
.
This error occurs only on a single computer. Other computers execute this code line well. On the other computers, I can see in SysInternals’ Process Explorer that right after successful execution of the line 26:, library DAO360.DLL gets loaded into the application process for the second time . That is why I suspect the error message «Error in loading DLL» says it failed to load DAO360.DLL for the second time.
Can you think of a reason why the call to the Fields property fails to load DAO360.DLL for the second time on the particular computer while it succeeds on others?
Thank you,
Radovan
Answers
It was missing KEY_CLASSES_ROOTTypeLib <00025e01-0000-0000-c000-000000000046>registry key. In spite of my registering Dao360.dll and Msado15.dll as stated in the second update of this thread (5th June 2017), the registry key was still absent. After adding the key as per https://support.microsoft.com/en-sg/help/2019235/microsoft-office-access-error-in-loading-dll the error message has not recurred.
I removed or renamed the registry key on several Windows machines to verify the absence of the key is the cause of the error message. Removing or renaming the key always led to DAO.Recordset.Fields and DAO.Database.TableDefs properties returning the «Error in loading DLL» message.
Thank you for your help Celeste and Dirk.
I’m not sure what the problem is, but the fact that it occurs only on one machine suggests that maybe DAO isn’t properly installed on that machine. Is the database in question an .mdb file, or is it an .accdb? Is any version of Access installed on that machine, or just DAO alone? If Access is installed, can the database be opened in Access?
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html
According to the error and your description, I suggest you visit the following links to check the registry keys of DAO360.DLL and how to register the Dao360.dll.
MSDN Community Support
Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Hello Dirk,
thank you for your reply.
These are my answers your questions:
Is the database in question an .mdb file, or is it an .accdb?
[Radovan] It is and .MDB file.
Is any version of Access installed on that machine, or just DAO alone?
[Radovan] MS Office 2010 including Access is installed on the machine. The machine is running Windows 7 (6.1.xxxx) Japanese. DAO is hence installed alongside the operating system.
If Access is installed, can the database be opened in Access?
[Radovan] Yes, the .MDB file can be opened and edited in Access.
Thank you,
Radovan
Hello Celeste,
thank you for your reply.
I checked the links in your reply. The suggested remedies, however, did not help.
Per KB833220 (https://support.microsoft.com/en-sg/help/833220/-error-in-loading-dll-error-message-when-you-run-a-microsoft-access-wizard-in-access)
1) I re-registered Dao360.dll and Msado15.dll at C:Program FilesCommon Filesmicrosoft sharedDAO and C:Program FilesCommon FilesSystemado resp.
2) Downloaded MDAC 2.8 SP1 installer from http://msdn.microsoft.com/en-us/data/aa937729.aspx and tried to run it. The installation spewed out a few progress dialogs, but I do not think it installed anything since Windows 7, which is the troublesome machine OS, installs the latest DAO alongside. Moreover all files at C:Program FilesCommon Filesmicrosoft sharedDAO and C:Program FilesCommon FilesSystemado are modifiable only by «TrustedInstaller».
I tried my own fix which consisted in renaming folders DAO and ado at C:Program FilesCommon Filesmicrosoft shared and C:Program FilesCommon FilesSystem resp. and running
to have Windows reinstall the potentially corrupted DAO files. The sfc utility restored the renamed DAO and ado folders with the original OS version.
After each attempt — 1,2, my own — I verified whether the VB6 code snippet terminates with the «Error in loading DLL» message and it always did.
Would you have more ideas in store as to the cause and fix for this error?
Источник
FIX: Microsoft Office Access error in loading DLL
- The Microsoft Office Access error in loading DLL usually occurs when users try to import text or spreadsheets into a wizard.
- This issue can be easily fixed by installing a third-party software tool that can fix DLL files.
- If you’re getting the DLL loading error on MS Access, make sure you have the latest MDAC version.
- Follow our method below to ensure that you’ve registered all the necessary files.
- Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here) .
- Click Start Scan to find DLL files that could be causing PC problems.
- Click Repair All to replace broken DLLs with working versions
- Restoro has been downloaded by 0 readers this month.
MS Office’s Access is among the foremost database applications that millions of users utilize to set up databases, and for a reason. The app is great and filled with a wide variety of features.
However, some Access users have encountered an Error in loading DLL message when they try to run wizards within the software, which makes it hard for them to use the software.
Thus, the error can arise when users try to import text or spreadsheets with the required wizards. The Error in loading DLL error can crash the active Access window.
How do I fix the DLL loading error in Microsoft Access?
1. Use a third-party DLL fixer
Restoro is a premium software that will restore any faulty or compromised files on your PC, including DLL files and crucial system data as well.
Besides restoring your PC and keeping it clean, the program will also improve its performance and keep any malfware and adware away while browsing the internet.
Restoro is a reliable third-party DLL fixer which uses a built-in automated system and an online library full of functional DLLs to replace and repair any files that might be corrupted or damaged on your PC.
All you need to do to resolve your PC’s problems is to launch it, and simply follow the on-screen instructions to start the process, as everything else is covered by the software’s automated processes.
This is how you can fix registry errors using Restoro:
- Download and install Restoro.
- Launch the software.
- Wait for it to scan your PC for any stability issues and possible malware.
- Press Start Repair.
- Restart your PC for all the changes to take effect.
After this process is completed your PC will be as good as new, and you will no longer have to deal with BSoD errors, slow response times, or other similar issues.
Disclaimer: This program needs to be upgraded from the free version in order to perform some specific actions.
2. Register the Dao360 and Msado15 DLL files
- The official Microsoft resolution for the Error in loading DLL error is to register the Dao360 and Msado15 DLL files. To do so, open the Win + X menu with the Windows key + X hotkey.
- Select Run to open that accessory.
- Search for the following in the Run’s text box then select Ok: Regsvr32.exeC:ProgramFilesCommonFilesMicrosoftSharedDAODao360.dll
- Then in Run, input the following and select Ok: Regsvr32.exeC:ProgramFilesCommonFilessystemadoMsado15.dll
3. Install the latest MDAC Version
Expert tip:
SPONSORED
Some PC issues are hard to tackle, especially when it comes to corrupted repositories or missing Windows files. If you are having troubles fixing an error, your system may be partially broken.
We recommend installing Restoro, a tool that will scan your machine and identify what the fault is.
Click here to download and start repairing.
Some users might need to update MDAC to fix the Error in loading DLL error. Once you’ve updated it, it is advised to restart your device.
Note: The software hasn’t been updated but it still works as intended, so you shouldn’t care much about it being discontinued. The latest version is 2.8.
4. Repair MS Office from the Programs and Features Applet
- Launch Run by pressing the Windows key + R keyboard shortcut.
- To open Windows’ uninstaller, enter appwiz.cpl in the text box.
- Then select the OK.
- Select the MS Office suite listed within the Programs and Features Control Panel applet.
- Then select the Change option.
- Thereafter, an MS Office dialog box window will open that includes a Repair option. Select it, and click the Continue button.
- MS Office 2016 users can select an Online Repair option to fix the suite’s applications.
- Thereafter, click Close when the repair, or configuration, the process is finished.
Note: Some users have confirmed they’ve fixed the Error in loading DLL error by selecting the Change option for MS Office on the Control Panel’s uninstaller applet.
5. Fix Access Files with the Access Repair Tool
- Click the Free Download Access Repair Tool button on the Access Repair Tool page to save the installer for that software.
- Open the installer Stellar Repair for Access installer to add the software to Windows.
- After opening the software, click the Browse button to select a file to repair.
- Then press the Repair button.
- Thereafter, the software displays a preview of the displayed file. Click Save Database to select a path to save file at.
If the Error in loading DLL arises for a more specific Access database file, try fixing it with Stellar Repair for Access, which has a demo version that users can try out.
Those are some of the more probable fixes for the error in loading DLL on Microsoft Access. With that error fixed, Access users can then utilize the application’s wizards for their databases.
Still having issues? Fix them with this tool:
Источник