Due to limitations in Ms Access, I have created a form in vb.net with
various buttons etc. Once all this is said and done, all i want to do is to
have this form fired up in ms access some how.
What i have tried, and got 'working' is compiling the vb.net program to a
tlb file, by clicking on the 'interop' checkbox under the projects 'build'
properties. This works fine, as i can now add a reference in Ms Access to
this tlb file, and create and show a new instance of my form in the vba
code.
The problem with this is that this program is going to be needed to run on
other machines. When i copy over the ms access files, and run them, all goes
well until i try to initiate and show my vb.net form. The error message is:
'ActiveX component cannot create object.'. Which to me says that the activeX
class isn't registered properly in the registry with a clsID etc.
I have tried various methods to get round this, including tlbExp.exe and
regasm.exe but neither have seemed to work. Could you please elaborate on
the way in which this CLSID stuff works, and subsequently why my problem
exists?
regards.
