I have a .Net assembly which I need to be able to use from three different program types;
-Microsoft Access (ver. 2000 I'm afraid)
Obviously I'm not too worried about that last one (VB.net) - as that's easy.
I've read a lot about adding assemblies to the GAC, but have never actually done it. I do have one assembly which I use in a VB6 app, but I don't use the GAC for this, I just deploy the TLB file and then call Regasm with the location of the TLB file specified as an argument.
In the playing around with all of this, trying to get it to work, I found it all quite messy. I was wondering if anyone has experience with getting MS Access to use a TLB file and if so, what the easiest way of deploying it all is. In my limited experience, I found that I had to put the TLB file in the same directory as MSACCESS.exe (i.e. C:\Program Files\Microsoft Office\Office) not the location of the MDB/MDE! Is this really the way it has to be?
If someone could outline the steps required as simply as possible, I would be most grateful.