Generating a DLL from Visual Basic 2008 to use with Access 2007

[jsprigg]

Howdy All,

I'm having a fair bit of trouble with this one.

I've got an API which is inaccessible from Access 2007 that I need to use with my database. After some tinkering I managed to get the API working under Visual Basic 2008 express.

What I'm trying to do now is to generate a DLL in Visual Basic that is compatible with Microsoft Access. All my attempts return "Runtime error '453' - Can't find DLL entry point testFunction in c:\temp\Test.dll"

I've been reading up on the problem and it sounds like the .NET dll has to be either converted to a .COM capable dll or I require the use of a wrapper. I've read (here) that I need to reference a COM or Type Library but I'm not sure which one or how to use it.

I'm a little green on the subject as this is the first time I've been trying to generate DLL files.

Any help would be much appreciated.

Cheers,

- Jeff