Using COM-Objects in Access?

[Carlo Trentoni]

HI,

is it possible to use COM-Objects in Access 2003? I received them within
an SDK for C#/Delphi, but would liek to use them in Access.

Carlo

 

[Albert D. Kallal]

HI,

is it possible to use COM-Objects in Access 2003? I received them within
an SDK for C#/Delphi, but would liek to use them in Access.

Carlo

Yes. They should work just fine in ms-access. Just ensure that the com
objects are installed and registered correctly.

When you use word or outlook automation from ms-access, then word/outlook is
a com object.

Access should be able to consume any windows application or program written
that supports "automation" or commonly referred to a com-object.

 

[David W. Fenton]

Access should be able to consume any windows application or
program written that supports "automation" or commonly referred to
a com-object.

Not necessarily. The WDSQuery.dll that is the querying interface to
Windows Desktop Search is COM, but can't be used by Access for some
reason. It's why I recently re-engineered most of the functionality
of the Office FileSearch Object as a class module -- because MS's
new search technology is not programmatically controllable from
within Access.

 

[Carlo Trentoni]

Hi Albert,

do you (or an other reader) have any example code/links for using
com-objects in Access VBA? All access books that I found had no chapters
about this.

Carlo

BTW: Do you know if the free Express Editions of Visual Basic and C#
support COM-objects? Or do I have to buy Visual Studio?

 

[Philip Herlihy]

Hi Albert,

do you (or an other reader) have any example code/links for using
com-objects in Access VBA? All access books that I found had no chapters
about this.

Carlo

BTW: Do you know if the free Express Editions of Visual Basic and C#
support COM-objects? Or do I have to buy Visual Studio?

An oldie but goodie:

http://support.microsoft.com/kb/198571

Phil, London