Adding .net 4.0 dll as a reference in MS-ACCESS

See more:

C#

MS-Access

ASP.NET4

Hello Everyone,
We are planning to develop 3 tier architecture ASP.NET 4.0 assembly or say class library dll in MS-ACCESS. The architecture is 3 tier architecture and using WCF, MS-ACCESS and SSRS.

HOW IT WORKS ?

I have to create one class library which invokes WCF service (Hosted on another machine, WCF is using nettcp binding) later, this WCF will invoke SSRS which is on different machine and finally our MS-ACCESS code will use class library dll added into it. User will pass the parameter from the MS-ACCESS and this will call WCF and eventually SSRS report will be generated.

ISSUE :
I have Created SSRS ,Class Library and WCF and did test on ASP.NET windows application and just worked fine. When i tried to use this class library dll in MS-ACCESS it started throwing an error.
ie.

Error Code: -2147024894
Automation Error
System can not find the file specified

CODE FOR MS-ACCESS USING .NET DLL

// Adding reference
Dim o As XYZ_SSRSReportCreation.CallWCFService

// CallWCFService is class 
Set o = New XYZ_SSRSReportCreation.CallWCFService

// Calling method , CallWindowService is method
MsgBox o.CallWindowService(txtDisplay)

Note :
1. I have created Strongly typed assembly and register it using regasm.exe from command prompt.
2. Class Library is created in VS2010 using Framework 4.0


Please help me moving forward. Any help will be appreciated.


Thanks in Advance