Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
reference question
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  13 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Mark Andrews  
View profile  
 More options Nov 6, 5:56 am
Newsgroups: microsoft.public.access
From: "Mark Andrews" <mandrewsNOS...@rptsoftware.com>
Date: Thu, 5 Nov 2009 13:56:21 -0500
Local: Fri, Nov 6 2009 5:56 am
Subject: reference question
I want to use Ostrosoft's SMTP component in a product that many people will
have to install.

Their newest product consists of a DLL and a TLB file.

If I put both files in the application directory and set a reference to the
TLB file everything works fine.

Wondering the best approach to use:
- Can I set a reference and it will still work if files are in application
directory?  Even if user installs application in different directory?
- Can I set the reference at runtime?
- should both files be in windows\system32?
Would rather not have to register anything if not needed.

I cannot rely on Outlook to be installed for emailing, so I need a third
party smtp (also I like a lot of the features of this product).

Thanks in advance for help,
Mark


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Douglas J. Steele  
View profile  
 More options Nov 6, 6:10 am
Newsgroups: microsoft.public.access
From: "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com>
Date: Thu, 5 Nov 2009 14:10:44 -0500
Local: Fri, Nov 6 2009 6:10 am
Subject: Re: reference question
Doesn't the vendor have any recommendations?

The best solution would be to use Late Binding if that's possible.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Mark Andrews" <mandrewsNOS...@rptsoftware.com> wrote in message

news:OJVPymkXKHA.5368@TK2MSFTNGP02.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Mark Andrews  
View profile  
 More options Nov 6, 7:36 am
Newsgroups: microsoft.public.access
From: "Mark Andrews" <mandrewsNOS...@rptsoftware.com>
Date: Thu, 5 Nov 2009 15:36:47 -0500
Local: Fri, Nov 6 2009 7:36 am
Subject: Re: reference question
They are difficult to get an answer from and they deal mostly with people
using .net.

I think I was mistaken and I do need to register the type library.  I had
the old library registered and certain code was still working off the old
library.

I believe some of the functionality I'm using requires early binding.  The
old product was just a dll (but they indicate they don't support activeX
anymore only COM on the new product).

Different question:
Know of any good ways to register a type library. I think I need Regtlb.exe
and it's not on this Vista machine.  Know of a good place to find it?

Mark

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:Oj8VuukXKHA.4360@TK2MSFTNGP04.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Douglas J. Steele  
View profile  
 More options Nov 6, 9:42 am
Newsgroups: microsoft.public.access
From: "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com>
Date: Thu, 5 Nov 2009 17:42:49 -0500
Local: Fri, Nov 6 2009 9:42 am
Subject: Re: reference question
I did a Bing on "regtlb.exe", and the first hit was
http://www.freevbcode.com/ShowCode.Asp?ID=2195

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Mark Andrews" <mandrewsNOS...@rptsoftware.com> wrote in message

news:uW726elXKHA.4808@TK2MSFTNGP06.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tony Toews [MVP]  
View profile  
 More options Nov 6, 3:11 pm
Newsgroups: microsoft.public.access
From: "Tony Toews [MVP]" <tto...@telusplanet.net>
Date: Thu, 05 Nov 2009 21:11:36 -0700
Local: Fri, Nov 6 2009 3:11 pm
Subject: Re: reference question

"Mark Andrews" <mandrewsNOS...@rptsoftware.com> wrote:
>I want to use Ostrosoft's SMTP component in a product that many people will
>have to install.

>Their newest product consists of a DLL and a TLB file.

>If I put both files in the application directory and set a reference to the
>TLB file everything works fine.

>Wondering the best approach to use:
>- Can I set a reference and it will still work if files are in application
>directory?  Even if user installs application in different directory?
>- Can I set the reference at runtime?
>- should both files be in windows\system32?

You might need to register the tlb file on your machine.  I don't know
much about tlb files though.   But my limited understanding is that
the tlb file is just for development purposes and you don't need to
distribute it.

Also I don't you can register a DLL so it should be enough to include
it in the same folder at your users.

This kind of stuff should be tested using a virtual machine such as
Virtual PC or VMWare or others.   They make testing this very easy.
Tip.  Create a new OS install in the VM.  Once it's setup, has all the
patches and anti virus installed shut it down.  Make a copy of the
virtual hard drive and install your program into the copy.  Test away
for a while.  Once you've decided you've "polluted" this VM delete it
and make a fresh copy of the virtual hard drive.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
  updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Mark Andrews  
View profile  
 More options Nov 6, 3:43 pm
Newsgroups: microsoft.public.access
From: "Mark Andrews" <mandrewsNOS...@rptsoftware.com>
Date: Thu, 5 Nov 2009 23:43:14 -0500
Local: Fri, Nov 6 2009 3:43 pm
Subject: Re: reference question
Thanks, not sure why I wasn't finding it?

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:OAUdNlmXKHA.4588@TK2MSFTNGP04.phx.gbl...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
David W. Fenton  
View profile  
 More options Nov 7, 7:03 am
Newsgroups: microsoft.public.access
From: "David W. Fenton" <XXXuse...@dfenton.com.invalid>
Date: 6 Nov 2009 20:03:06 GMT
Local: Sat, Nov 7 2009 7:03 am
Subject: Re: reference question
"Tony Toews [MVP]" <tto...@telusplanet.net> wrote in
news:i887f5p8q6tm557eb6c2n37l50ie0hml7h@4ax.com:

> I don't know
> much about tlb files though.   But my limited understanding is
> that the tlb file is just for development purposes and you don't
> need to distribute it.

I'm pretty sure (but could not confirm it with a bit of Googling)
that the TLB file is a wrapper around a COM library the purpose of
which is to support high-level IDE functions like the Object Browser
and Intellisense in the VBE. The absence of a TLB file does not
preclude the use of the underlying functionality of the COM library
it is a wrapper around -- it's just less user-friendly for those use
MS IDEs (or any other IDE that knows how to use a COM TLB file).

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
David W. Fenton  
View profile  
 More options Nov 7, 7:09 am
Newsgroups: microsoft.public.access
From: "David W. Fenton" <XXXuse...@dfenton.com.invalid>
Date: 6 Nov 2009 20:09:41 GMT
Local: Sat, Nov 7 2009 7:09 am
Subject: Re: reference question
"Mark Andrews" <mandrewsNOS...@rptsoftware.com> wrote in
news:uW726elXKHA.4808@TK2MSFTNGP06.phx.gbl:

> They are difficult to get an answer from and they deal mostly with
> people using .net.

> I think I was mistaken and I do need to register the type library.
>  I had the old library registered and certain code was still
> working off the old library.

> I believe some of the functionality I'm using requires early
> binding.

If it's registered, it should be usable via late binding. However,
it may not work as well (depending on what it does and how it's
structured). It's really a matter of finding what top-level object
you're using with CreateObject("My.Application"), and some registry
browsing can find that.

What I usually do is use early binding for development and to figure
out the object model, and then convert to late binding for
production use. Sometimes I'll maintain a separate MDB with the
reference so that during development after conversion to late
binding I don't have to add the reference back to my production
database.

>  The
> old product was just a dll (but they indicate they don't support
> activeX anymore only COM on the new product).

That's gibberish. "ActiveX" is just a rebranding of "COM" which was
a rebranding of "OLE." A DLL may or may not be a full COM object
("COM" is the winner after all of these years, and it's what
everyone uses to refer to the technology) -- depends on what
interfaces it supports.

> Different question:
> Know of any good ways to register a type library. I think I need
> Regtlb.exe and it's not on this Vista machine.  Know of a good
> place to find it?

The Access VBE's references browser will register a TLB file if it's
not already, just as if you point at an unregistered (and
registerable) DLL, it will register that without running REGSVR32.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tony Toews [MVP]  
View profile  
 More options Nov 7, 9:31 am
Newsgroups: microsoft.public.access
From: "Tony Toews [MVP]" <tto...@telusplanet.net>
Date: Fri, 06 Nov 2009 15:31:46 -0700
Local: Sat, Nov 7 2009 9:31 am
Subject: Re: reference question
"David W. Fenton" <XXXuse...@dfenton.com.invalid> wrote:

>> I don't know
>> much about tlb files though.   But my limited understanding is
>> that the tlb file is just for development purposes and you don't
>> need to distribute it.

>I'm pretty sure (but could not confirm it with a bit of Googling)
>that the TLB file is a wrapper around a COM library the purpose of
>which is to support high-level IDE functions like the Object Browser
>and Intellisense in the VBE. The absence of a TLB file does not
>preclude the use of the underlying functionality of the COM library
>it is a wrapper around -- it's just less user-friendly for those use
>MS IDEs (or any other IDE that knows how to use a COM TLB file).

Ok, that makes some sense.   I'm using a TLB file in the Auto FE
Updater for reading and creating shortcuts.

That said I have no idea what COM really means.  

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
  updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Mark Andrews  
View profile  
 More options Nov 8, 12:45 am
Newsgroups: microsoft.public.access
From: "Mark Andrews" <mandrewsNOS...@rptsoftware.com>
Date: Sat, 7 Nov 2009 08:45:41 -0500
Local: Sun, Nov 8 2009 12:45 am
Subject: Re: reference question
David,

Thanks for the info.  You wouldn't want to take a look at
http://www.ostrosoft.com/smtp_component.asp
and help me figure out the best way to use this component?

Would love to figure out a way that I don't need to register it (and just
include the files in the directory the front-end db lives).

I would think using something like this component would help tons of people
struggling with emailing from Access as well.

Thanks,
Mark

"David W. Fenton" <XXXuse...@dfenton.com.invalid> wrote in message
news:Xns9CBB9A9527A94f99a49ed1d0c49c5bbb2@74.209.136.100...


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Tony Toews [MVP]  
View profile  
 More options Nov 8, 11:12 am
Newsgroups: microsoft.public.access
From: "Tony Toews [MVP]" <tto...@telusplanet.net>
Date: Sat, 07 Nov 2009 17:12:18 -0700
Local: Sun, Nov 8 2009 11:12 am
Subject: Re: reference question

"Mark Andrews" <mandrewsNOS...@rptsoftware.com> wrote:
>Thanks for the info.  You wouldn't want to take a look at
>http://www.ostrosoft.com/smtp_component.asp
>and help me figure out the best way to use this component?

>Would love to figure out a way that I don't need to register it (and just
>include the files in the directory the front-end db lives).

>I would think using something like this component would help tons of people
>struggling with emailing from Access as well.

Download the Using with Visual Basic example and poke about with
Notepad.  In particular note the references, it has quite a few.

But be advised that when I ran it in VB 6.0, with the DLLs in the
directory,  I got the following message
ActiveX component can't create object
And that was with the OSSMTP_Plus DLL and tlb in the same folder as
the VB 6 source code.  So it may require registering anyhow.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
  updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
David W. Fenton  
View profile  
 More options Nov 8, 11:18 am
Newsgroups: microsoft.public.access
From: "David W. Fenton" <XXXuse...@dfenton.com.invalid>
Date: 8 Nov 2009 00:18:58 GMT
Local: Sun, Nov 8 2009 11:18 am
Subject: Re: reference question
"Tony Toews [MVP]" <tto...@telusplanet.net> wrote in
news:8n89f5hf4pksli5dkqj5qiqh4pj6ekegc8@4ax.com:

> That said I have no idea what COM really means.

Er, Office has been entirely based on it since at least 1994 (the
registry existed back in the day for coordinating OLE in that
version of Office) and all versions of Windows since Win95 have it
fully baked in at all levels.

You might want to read this:

  http://en.wikipedia.org/wiki/Component_Object_Model

You're using COM all the time -- it's the entire basis for
references in Access, as well as for late binding (which depends on
COM registration of the components you're using). The Windows System
registry is the heart of COM, because it defines all the
relationships between the components.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
David W. Fenton  
View profile  
 More options Nov 8, 11:23 am
Newsgroups: microsoft.public.access
From: "David W. Fenton" <XXXuse...@dfenton.com.invalid>
Date: 8 Nov 2009 00:23:22 GMT
Local: Sun, Nov 8 2009 11:23 am
Subject: Re: reference question
"Mark Andrews" <mandrewsNOS...@rptsoftware.com> wrote in
news:uc1WmC7XKHA.3600@TK2MSFTNGP04.phx.gbl:

> You wouldn't want to take a look at
> http://www.ostrosoft.com/smtp_component.asp
> and help me figure out the best way to use this component?

The first line of the cited page explains why you are having
problems. It says:

  OstroSoft SMTP Component is a .NET library

.NET is not COM and that's why it doesn't work well with COM.

For it to work, it has to have a COM wrapper somewhere to expose
it's interfaces in COM-compatible format.

I would stick with COM-only for Access development if I were you.

I also wouldn't use outside libraries for email. If I were
contemplating sending email without automating Outlook, I'd likely
do it straight MAPI. It's very difficult, but you'd not be dependent
on somebody else's components to make it work. Tony has a page on
email that lists all the alternatives for sending email from Access:

  http://www.granite.ab.ca/access/email.htm

It's a very problematic area because MAPI has actually never been
very good at all.

--
David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google