Error in loading DLL

  • Thread starter Thread starter Amir
  • Start date Start date
A

Amir

Hi,

I'm trying to use automation from Access to create new Outlook mail message.
This works fine in all of the computers, but the same code fails only in one
of the computers, showing error message no. 48: Error in loading DLL.

I've tried uninstalling then reinstalling Office, resetting the References,
copying the outlook library reference file from a computer in which the code
works to the failing computer, but non of these helped.

All computers (including the one in which the code doesn't work) are working
with Access 2002, while the rest of the office programs are of version 2000,
including Outlook 2000. I mean, all of these computers (both the ones on
which the code works and the one on which the code doesn't work) are
running:

Access 2002 (XP)
Outlook 2000
Excel 2000
Word 2000

What is causing the DLL error?
How can I solve that?
 
Can you create a message using the Outlook UI on the problem machine? At
what exact step do you get the error? (show the place in your code)
 
I currently don't have access to the bad computer, but I think it's on line
2:

1. Dim olApp As Outlook.Application
2. Set olApp = Outlook.Application 'This gives error

I think it's similar to the problem described in the following page:
http://www.pcreview.co.uk/forums/thread-1105446.php

But I havn't tried yet using late binding.

What is causing this problem?
 
Is the machine that fails accessible to you? What happens if you try to
compile the Access app on that machine (Code window > Debug > Compile
<appname>)? Can you automate other Office 2000 apps from it?
 
Hi, Thanks for your response.

Sorry for the late respone. I still don't have access to that machine, so
I'll describe what I remember for now:

1. I am able to create a message using the Outlook UI.
2. Compile completes successfuly also in the problematic machine.
3. I was able to automate Excel2000, but I'm not sure if I was using early
or late binding in order to do so. I havn't tried yet using late binding
there to automate Outlook. In a few days I'll get access to the problematic
machine, so I'll try late binding. Are there more things I should check
there?

Regards,
Amir.
 
OK, I've got access to that computer, tried late binding, but it still
doesn't work: same error on the same line.
I have no idea what to do next, except for trying to reinstall Windows or
something like that.

Regards,
Amir.
 
Back
Top