Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2006

Tip: Looking for answers? Try searching our database.

VBA Module: Time Limitation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rix - 07 Sep 2006 16:35 GMT
Hello Guys,
Our coder built our software as a VBA module for MSAccess.

It is turning out to be a great software, we would like to be able to limit
potential customers access to it for 30 Days, basically give them a working
copy (Demo) for 30 days.

Does Anyone know how I could do this?
Doug Robbins - Word MVP - 07 Sep 2006 19:09 GMT
If you have the expiry date hard coded into the application and you have
applied protection to it, you can simply set up an If - End If routine at
the beginning of the code that exits if the date has been exceeded (probably
displaying a message box would be a good idea).

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello Guys,
> Our coder built our software as a VBA module for MSAccess.
[quoted text clipped - 6 lines]
>
> Does Anyone know how I could do this?
Karl E. Peterson - 07 Sep 2006 19:15 GMT
> If you have the expiry date hard coded into the application and you
> have applied protection to it,
      ^^^^^^^ ^^^^^^^^^^

How, exactly, might one do that?
Signature

Working without a .NET?
http://classicvb.org/

Jean-Guy Marcil - 07 Sep 2006 19:58 GMT
Karl E. Peterson was telling us:
Karl E. Peterson nous racontait que :

>> If you have the expiry date hard coded into the application and you
>> have applied protection to it,
>       ^^^^^^^ ^^^^^^^^^^
>
> How, exactly, might one do that?

I think that Doug is referring to a password set to the template project.

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Karl E. Peterson - 07 Sep 2006 20:03 GMT
> Karl E. Peterson was telling us:
> Karl E. Peterson nous racontait que :
[quoted text clipped - 6 lines]
> I think that Doug is referring to a password set to the template
> project.

That was my first thought, as well, but those provide no real protection at
all?
Signature

Working without a .NET?
http://classicvb.org/

Jean-Guy Marcil - 07 Sep 2006 20:29 GMT
Karl E. Peterson was telling us:
Karl E. Peterson nous racontait que :

>> Karl E. Peterson was telling us:
>> Karl E. Peterson nous racontait que :
[quoted text clipped - 9 lines]
> That was my first thought, as well, but those provide no real
> protection at all?

Yes, but most people do not know that.

In this case, if protecting the code from prying eyes is important, the
whole project should be compiled in a DLL...

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Karl E. Peterson - 07 Sep 2006 21:11 GMT
> Karl E. Peterson was telling us:
> Karl E. Peterson nous racontait que :
[quoted text clipped - 14 lines]
>
> Yes, but most people do not know that.

If by most you mean those who aren't likely to be trying to break into the
projects, you're probably right.  But don't kid yourself.  Anyone who
*wants* to get in, will.

I know I've had clients who were totally unaware.  I'd download their
"protected" samples, and within moments start telling them what's wrong with
the code, much to their dismay.

> In this case, if protecting the code from prying eyes is important,
> the whole project should be compiled in a DLL...

Key portions, at least, yep.  I've helped a good number of folks set that
sort of thing up.  The key is education, and not letting folks feel a sense
of false security.
Signature

Working without a .NET?
http://classicvb.org/

Cindy M. - 08 Sep 2006 11:00 GMT
Hi Jean-Guy,

> >> If you have the expiry date hard coded into the application and you
> >> have applied protection to it,
[quoted text clipped - 3 lines]
>  
> I think that Doug is referring to a password set to the template project.

Actually, the OP has an ACCESS (not Word) project. So this approach could
work IF he has the Access Developer runtime and compiles to an MDE...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Jezebel - 08 Sep 2006 11:08 GMT
Have you ever met (or even heard of) *anyone* who achieved a good result
with an MDE in real world practice? I've met several disasters and nothing
that even remotely resembled a success. But only from a very limited sample.

> Hi Jean-Guy,
>
[quoted text clipped - 16 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
Cindy M. - 08 Sep 2006 13:03 GMT
Hi Jezebel,

> Have you ever met (or even heard of) *anyone* who achieved a good result
> with an MDE in real world practice?

I haven't discussed this with Access folks, recently. I have to admit that
my one venture into the MDE world was less than successful, and I never
wanted to get within spitting distance, after that :-)

   Cindy Meister
Jezebel - 08 Sep 2006 23:39 GMT
> I haven't discussed this with Access folks, recently. I have to admit that
> my one venture into the MDE world was less than successful, and I never
> wanted to get within spitting distance, after that :-)

Yep, that sums it up for me too.
Jean-Guy Marcil - 08 Sep 2006 12:27 GMT
Cindy M. was telling us:
Cindy M. nous racontait que :

> Hi Jean-Guy,
>
[quoted text clipped - 10 lines]
> could work IF he has the Access Developer runtime and compiles to an
> MDE...

That'll teach me not to read the full thread before jumping in!
But of course, it is perfectly normal to have an Access question in a Word
group... especially a beginner group! ;-)

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Karl E. Peterson - 08 Sep 2006 20:58 GMT
> Cindy M. was telling us:
> Cindy M. nous racontait que :
[quoted text clipped - 17 lines]
> But of course, it is perfectly normal to have an Access question in a
> Word group... especially a beginner group! ;-)

Heh, yeah, "ouch."  Goes to show me, too. <g>
Signature

Working without a .NET?
http://classicvb.org/

Doug Robbins - Word MVP - 08 Sep 2006 21:11 GMT
And me.   I guess I just assumed that as it was posted to a Word newsgroup
that somewhere along the way a Word template was being used.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>> Cindy M. was telling us:
>> Cindy M. nous racontait que :
[quoted text clipped - 19 lines]
>
> Heh, yeah, "ouch."  Goes to show me, too. <g>

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.