VBA Module: Time Limitation

[Rix]

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]

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).



--
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

 

[Karl E. Peterson]

If you have the expiry date hard coded into the application and you
have applied protection to it,

^^^^^^^ ^^^^^^^^^^

How, exactly, might one do that?

 

[Jean-Guy Marcil]

Karl E. Peterson was telling us:
Karl E. Peterson nous racontait que :

^^^^^^^ ^^^^^^^^^^

How, exactly, might one do that?

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

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Karl E. Peterson]

Karl E. Peterson was telling us:
Karl E. Peterson nous racontait que :


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?

 

[Jean-Guy Marcil]

Karl E. Peterson was telling us:
Karl E. Peterson nous racontait que :

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...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Karl E. Peterson]

Karl E. Peterson was telling us:
Karl E. Peterson nous racontait que :


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.

 

[Cindy M.]

Hi Jean-Guy,

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]

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.

 

[Jean-Guy Marcil]

Cindy M. was telling us:
Cindy M. nous racontait que :

Hi Jean-Guy,

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...

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! ;-)

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Cindy M.]

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

 

[Karl E. Peterson]

Cindy M. was telling us:
Cindy M. nous racontait que :


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! ;-)

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

 

[Doug Robbins - Word MVP]

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.

--
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

 

[Jezebel]

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.