Re: Best way to create ActiveX for Access 2000 in (vb).net

On 26 feb, 14:32, Patrick Steele <patr...@xxxxxxxx> wrote:
In article <1172486722.969042.117...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
hagi...@xxxxxxxxx says...



Hi,

I'm currently expanding the capability of an Access 2000 database for
a customer who's limited by the "regime" of it's IT-department.

The client wishes to do things in his Access 2000 (with VBA) that are
easily done in (vb).NET.

I have finished an ActiveX component that works well when tested in a
VB.NET 2003 environment using 1.1 framework (client has 1.1
installed).

I've got register class and unregister class (inprocserver32 etc.) and
when compiled, on the same machine it works wonderfully well in Access
2003. However, the customer uses Access 2000 and Windows 2000.

So I've created a virtual machine running Windows 2000 with Access
2000.

My question now is (application has strong name) how would I implement
this the right way. I've used Regasm and I've checked "register for
COM interop". I've placed the .dll and .tlb in the same folder as
MSACCESS.EXE and still I'm experiencing difficulties. Like Access
mentioning it's not registered properly, or when it finally works the
next time you enter the form it's says something about the ActiveX
component containing no control.

Have you applied all of the proper attributes and things to make sure
your .NET object is exposed to COM cleanly? See:

http://www.15seconds.com/issue/040721.htm

--
Patrick Steelehttp://weblogs.asp.net/psteele

Hi Patrick,

Thanks for replying. Interesting stuff you've mentioned there. Yes,
it's exposed
cleanly as far as I can see.

It's odd. I simply use regasm /codebase myactivex.dll and the Access
2000
database can't do anything with it (complaining it's not registered,
although
showing up in the ActiveX list of registrered controls).

However, as mentioned, it's working perfectly in my Access 2003
database
but that's perhaps because my Visual Studio .NET resides on that
computer.

Just for fun of it, I copied this Access 2003 database (Access 2000
format) to
the virtual machine having the problem.

It says (translated sorry) "This controlelement doesn't contain an
object". The
form shows an empty (white) control. I close the form, re-open it in
design and
voila, no problem at all. It even exposes my properties nicely.

Martin.

.

Relevant Pages

  • Accepting Bids on Web application programming Development contract
    ... Real Estate Multipliable Listing Service Web application. ... customer as pkzip or tar ... Register function common specs ... time you search the real estate record database for the ...
    (freebsd-questions)
  • Accepting Bids on Web application programming Development contract
    ... Real Estate Multipliable Listing Service Web application. ... customer as pkzip or tar ... Register function common specs ... time you search the real estate record database for the ...
    (freebsd-questions)
  • Re: Best way to create ActiveX for Access 2000 in (vb).net
    ... the customer uses Access 2000 and Windows 2000. ... I've used Regasm and I've checked "register for ... database can't do anything with it (complaining it's not registered, ... form shows an empty control. ...
    (microsoft.public.dotnet.framework.interop)
  • treeview control
    ... the customer a working model of our database. ... database we are implementing the treeview ... control extensively to give the ... customer visibility into our data at different levels. ...
    (microsoft.public.access.formscoding)
  • Re: Sequential Record numbering
    ... numbering system for my database. ... sequential record numbering system. ... I have a table named "Customer Info" with a field named "Customer ... I used a sample control name because the terminology you used in your second ...
    (microsoft.public.access.forms)