[AccessD] DirWatcher - was RE: Cool stuff - was RE: using adtsx in .Net

Jon,
I am reading the thread with great interest.
I think a lot us hanging out in this forum are seeing the need of getting up to speed with .net and sql server etc.
... and wishing we had more time.

if you have time, would you mind going through the steps involved for creating what you did.

I understand there is a .net object - among the many thousands -  you refer to as "DotNet DiskWatcher object". - What's the name?

You write some .net code using this object that will monitor a Folder and alert you when things happens in the folder. What does the
code look like.

Then you write a "wrapper" so the .net code can be used in VB and more of interest in VBA.
What does the wrapper code look like - the com object?

Then there is the issue of registered the com object.
Marty is writing about certain code for using this.
What's the connection between the .dll file and .tlb file ?
Is the .dll file the file that contains the com object. what's the function of the tlb file?

You didn't need to register the com object as it gets registered on the machine you built the code on.

You then used the com object in some vba code, copy of which you showed us, right?

hmmm.... so much ... to get around to finding a 'easy' way to make .net functionality available in vba code

Here's another link:
Visual Basic Fusion: Best Practices to Use Visual Basic 6 and Visual Basic .NET Together
http://msdn2.microsoft.com/en-us/library/ms364069(vs.80).aspx

borge


----- Original Message ----- 
From: "JWColby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Sent: Sunday, April 22, 2007 9:22 AM
Subject: Re: [AccessD] DirWatcher - was RE: Cool stuff - was RE: using adtsx in .Net


Marty,

I didn't have to do a register on this machine since it was the one that I
created the VB.Net project on and the simple act of building it caused it to
be registered.  I will certainly look at that stuff if I need to do this on
another machine (actually use this thing).

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Saturday, April 21, 2007 6:52 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] DirWatcher - was RE: Cool stuff - was RE: using a
dtsx in .Net

Just wondering, if you used this method to register the com class dll.
It uses regasm and gacutil to remove any previously named dll and reinstalls
in the registry.
See :
http://samples.gotdotnet.com/quickstart/howto/doc/Interop/Building_Samples_C
OM2NET.aspx

the install batch file looks like this for your dll FX20Wrapper.dll

regasm
"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\system.windows.forms.dll"

gacutil -u FX20Wrapper
regasm /u "VB2005\FX20Wrapper\bin\Release\FX20Wrapper.dll"

regasm /tlb "VB2005\FX20Wrapper\bin\Release\FX20Wrapper.dll"
gacutil -i "VB2005\FX20Wrapper\bin\Release\FX20Wrapper.dll"

To use Access set a reference to the tlb file that will be in a directory
like below depending on where you installed the project.
\VB2005\FX20Wrapper\bin\Release\FX20Wrapper.tlb

The tlb will allow Access to see the class definitions and do a compile.



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.6/770 - Release Date: 4/20/2007 6:43 PM