Error in loading dll excel как исправить
Обновлено: 04.07.2024
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.
All replies
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 <<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 Files\Common Files\Microsoft Shared\DAO\Dao360.dll"
Regsvr32.exe "C:\Program Files\Common Files\system\ado\Msado15.dll"
DllRegisterServer in C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.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 Files\Common Files\system\ado\Msado15.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:
При попытке запуска мастеров в Microsoft Office Access, таких как мастера импорта, мастер запросов, мастер отчетов и мастера управления, вы получаете одну из следующих ошибок:
Причина
Один из следующих ключей реестра может не существовать.
ACEDAO.DLL
Установки MSI
Клавиша: HKEY_CLASSES_ROOT\ TypeLib\\c.0\0\win32
Строка: (по умолчанию)
Значение: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL
Клавиша: HKEY_CLASSES_ROOT\ TypeLib\\c.0\0\win64
Строка: (по умолчанию)
Значение: C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL
Клавиша: HKEY_CLASSES_ROOT\ TypeLib\\c.0\0\win32
Строка: (по умолчанию)
Значение: C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL
Office14 используется в пути ключа реестра выше. Это должно представлять текущую версию установленного access.
- OFFICE12 - Access 2007
- OFFICE14 - Access 2010
- OFFICE15 - Access 2013
- OFFICE16 — Access 2016
Установки click-to-Run
Клавиша: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\SOFTWARE\Classes\TypeLib\\c.0\0\win32
Строка: (по умолчанию)
Значение: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL
Клавиша: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\SOFTWARE\Classes\TypeLib\\c.0\0\win64
Строка: (по умолчанию)
Значение: C:\Program Files\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL
Клавиша: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\SOFTWARE\Classes\TypeLib\\c.0\0\win32
Строка: (по умолчанию)
Значение: C:\Program Files\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL
DAO360.DLL
Клавиша: HKEY_CLASSES_ROOT\TYPELIB\\5.0\0\win32
Строка: (по умолчанию)
Значение:%CommonProgramFiles (x86)%\Microsoft Shared\DAO\dao360.dll
(64-Windows, 64-Office) или (32-Windows, 32-Office)
Клавиша: HKEY_CLASSES_ROOT\TYPELIB\\5.0\0\win32
Строка: (по умолчанию)
Значение:%CommonProgramFiles%\Microsoft Shared\DAO\dao360.dll
Решение
Самостоятельное решение проблемы
Указанные ниже действия устраняют проблему, задав правильные значения для этих dlls в реестре.
При неправильном изменении реестра с использованием редактора реестра или другого способа могут случиться серьезные проблемы. Для решения этих проблем может потребоваться переустановка операционной системы. Компания Microsoft не может гарантировать, что эти проблемы могут быть решены. Вносите изменения в реестр на ваш страх и риск.
Действия по воссоздание ключей для MSI Installations:
Скопируйте и вклейте следующие строки текста для среды, начиная с Windows редактора реестра Версии 5.00, в Блокнот документ:
Убедитесь, что версия office (OFFICE14), указанная в пути, соответствует соответствующему значению из списка в начале этой статьи.
Сохраните Блокнот как Win32Keys.reg.
Выполните одно из указанных ниже действий.
- Используя Windows Explorer, дважды щелкните файл Win32Keys.reg для его запуска.
- В редакторе реестра перейдите к импорту файлов, чтобы просмотреть, где сохранен файл > Win32Keys.reg, а затем нажмите кнопку Открыть.
Дополнительные сведения
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\\c.0\0\win32
String: (Default)
Value: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_CLASSES_ROOT\ TypeLib\\c.0\0\win64
String: (Default)
Value: C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_CLASSES_ROOT\ TypeLib\\c.0\0\win32
String: (Default)
Value: C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEDAO.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_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\SOFTWARE\Classes\TypeLib\\c.0\0\win32
String: (Default)
Value: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL
(64-bit Windows, 64-bit Office):
Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\SOFTWARE\Classes\TypeLib\\c.0\0\win64
String: (Default)
Value: C:\Program Files\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL
(32-bit Windows, 32-bit Office):
Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\ClickToRun\REGISTRY\MACHINE\SOFTWARE\Classes\TypeLib\\c.0\0\win32
String: (Default)
Value: C:\Program Files\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL
DAO360.DLL
(64-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles(x86)%\Microsoft Shared\DAO\dao360.dll
(64-bit Windows, 64-bit Office) or (32-bit Windows, 32-bit Office)
String: (Default)
Value: %CommonProgramFiles%\Microsoft Shared\DAO\dao360.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_ROOT\TYPELIB\\5.0\0\win32 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 .
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 <<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 Files\Common Files\Microsoft Shared\DAO\Dao360.dll"
Regsvr32.exe "C:\Program Files\Common Files\system\ado\Msado15.dll"
DllRegisterServer in C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.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 Files\Common Files\system\ado\Msado15.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:
Читайте также: