Hello. Access 2007.
When attempting to use the Import Spreadsheet wizard when I get past the first dialog it says 'Could not locate dll'. It also happened with the lookup wizard but I was able to click past it.
I have both Access 2007 and 2010 but they are supposed to be able to live together and I've not come across this issue before.
I believe it's a question of re-registering dll's but I'm not sure which one(s)? Any ideas pl? Andy.
Could not find dll
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Could not find dll
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Could not find dll
Actually, it's "error in loading dll".
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78537
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Could not find dll
Try reregistering msexcl40.dll. This is the Excel Jet ISAM file. It can be found in C:\Windows\System32 if you have 32-bits Windows or in C:\Windows\SysWOW64 if you have 64-bits Windows.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Could not find dll
Hi.HansV wrote:Try reregistering msexcl40.dll. This is the Excel Jet ISAM file. It can be found in C:\Windows\System32 if you have 32-bits Windows or in C:\Windows\SysWOW64 if you have 64-bits Windows.
I "Ran" regsvr32.exe "C:\Windows\SysWOW64\msexcl40.dll" but still no joy
I re-registered dao360.dll and msado15.dll as well prior to the above as well. Andy. Mmm.. is it then called regsvr64.exe I wonder?
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78537
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Could not find dll
You don't have to use regsvr64 as far as I know.
You might also try AccWiz.dll (in C:\Program Files (x86)\Microsoft Office\Office12 for Access 2007, in C:\Program Files (x86)\Microsoft Office\Office14 for Access 2010).
You might also try AccWiz.dll (in C:\Program Files (x86)\Microsoft Office\Office12 for Access 2007, in C:\Program Files (x86)\Microsoft Office\Office14 for Access 2010).
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Could not find dll
Should have mentioned that one as well. I even triedHansV wrote:You don't have to use regsvr64 as far as I know.
You might also try AccWiz.dll (in C:\Program Files (x86)\Microsoft Office\Office12 for Access 2007, in C:\Program Files (x86)\Microsoft Office\Office14 for Access 2010).
c:\windows\syswow64\regsvr32.exe "C:\Windows\SysWOW64\msexcl40.dll"
which is, strangely, the 64-bit version. Must be some combination of these I suppose.. Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78537
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Could not find dll
In the end, you may have to uninstall both versions of Office and install only one...
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Could not find dll
he, he.. I was just thinking, "I don't want to do that!".HansV wrote:In the end, you may have to uninstall both versions of Office and install only one...
Just trying an Office 2007 repair. I might even bite the bullet and install 2010 SP1 (which I've delayed as long as poss.).
Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Could not find dll
Hi. Nope, repair didnt' work.. Have to think about this one..
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Could not find dll
Hey, fixed (it seems, so far..) Saving the following as a file called 'win32key.reg' and double-clicking it:
So simple when you know how! Andy.
Code: Select all
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\TypeLib\{00025E01-0000-0000-C000-000000000046}\5.0\0\win32]
@=hex(2):25,00,43,00,6f,00,6d,00,6d,00,6f,00,6e,00,50,00,72,00,6f,00,67,00,72, 00,61,00,6d,00,46,00,69,00,6c,00,65,00,73,00,25,00,5c,00,4d,00,69,00,63,00, 72,00,6f,00,73,00,6f,00,66,00,74,00,20,00,53,00,68,00,61,00,72,00,65,00,64, 00,5c,00,44,00,41,00,4f,00,5c,00,64,00,61,00,6f,00,33,00,36,00,30,00,2e,00, 64,00,6c,00,6c,00,00,00
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78537
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Could not find dll
What do you mean.. I worked it out myselfHansV wrote:Thanks - but how did you find that?
Nah, via microsoft, Knowledge Base, then a link to Microsoft Answers:
http://answers.microsoft.com/en-us/offi ... 1db61a9d2a
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78537
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands