Determine an end time for a DataBase

  • Thread starter Thread starter Maria Joao
  • Start date Start date
M

Maria Joao

Hi,

I need to make my database work until certain date.
After that I need it to close, and doesn't work.

How can I do that?

Thanks
 
Maria

One approach would be to add code behind the form that your db opens on
Startup. Each time the form opens, it could check the current date and
compare it to your "certain date".

Of course, anyone who knows about the Shiftkey bypass could still open it...
unless you also disabled that.

Depending on what you are trying to accomplish, you might consider
converting your .mdb file into an .mde file...
 
I would think that one could change the date on their computer to get around
this as well.

I assume you are trying to package a trial version of your database? If so,
do a search for trial in these newsgroups. I have seen posts before.
Personally, that is above my expertise, but I have seen the experts post on
it before.

Rick B
 
Jeff

That is what I plan to do, but I need to know what is the
code that performs this event.

Can you help me with that?

Thansks in advance

Maria Joao
 
To do it. You need to save a date in a table or define it in code. Then it
would be
if enddate>=date$() then docmd.exit. You could do this in your autoexec
macro with runcode if you want or on your start up form in on open. This is
a lousy way of securing your demo. The tables can be imported, exported and
edited if they are in .mdb form. .mde isnt much better in terms of securing
your demo. The best option with date is have your own license text file that
is encrypted. Make sure if the file isn't there your program exits. In terms
of changing system date back if they keep an original copy of your license
file on first use there isn't much you can do. The best way i heard of doing
a demo is limit table size of important tables ie in an accounting software
the customer to 10 or invoices to 100. Then if they get a license file from
you it released the demo.

also look here
http://www.granite.ab.ca/access/demo.htm

HTH
Martin J
 
Back
Top