Results 1 to 6 of 6
  1. #1
    LeonS is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2014
    Posts
    115

    Make a 15 day trial version of my app in Access 2016


    Hello! First, I want to say Thank You to everyone who has helped me during the last few months! Although a database is never finished being developed, I have reached a point where I have said "Stop!". All the original facilities now work, I am delighted to say!! There is one facility I want to add, but later - after I have carried out my research.
    Thus, I want to move on to the next stage - testing. I plan to send my new db to a number of IT students to do some testing. BUT, I want to limit the time they can use it to 15 days. I have Googled and Googled but never get a meaningful answer. The answers are all about MS licensing!
    Can someone please point me in the right direction. Maybe I am asking the wrong question, or using the wrong words! Thank you - Leon

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you could program a hardcoded date, then when the Date() goes past, stop the execution.
    But you must lockout the code from users.
    make and .accde

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Perhaps
    Create a DB custom property that is created on first open and set with that date. Then check that property against all openings of the DB.?
    That way if someone does not initially open it for a week or so, they still get the 15 days. ACCDE as mentioned by ranman256
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You also need to protect against users bypassing the expiry date security by changing the system date.

    Having said that, if you want the IT students to test your app properly, then locking them out after 15 days may be counterproductive.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Quote Originally Posted by Welshgasman View Post
    Perhaps
    Create a DB custom property that is created on first open and set with that date. Then check that property against all openings of the DB.?
    That way if someone does not initially open it for a week or so, they still get the 15 days. ACCDE as mentioned by ranman256
    I cannot recall if one can alter a db property of an accde. I know I could on mdb or accdb but you know how the memory starts fading...
    So if it can be done, not real secure - but that's Access for you. Altering my system date would probably be the first junior hack, but you don't want to be sending emails or doing other date sensitive stuff. Ask me how I know.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I cannot recall if one can alter a db property of an accde
    you can but as you say, someone in the know can find it, so best to give the property a misleading name and obscure the value in some way

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Setting a trial version of my database
    By Emmanuel in forum Forms
    Replies: 11
    Last Post: 07-04-2021, 11:02 AM
  2. Publish Trial Version
    By RustyRick in forum Access
    Replies: 3
    Last Post: 04-02-2020, 01:15 PM
  3. Access trial version?
    By RhinoCan in forum Access
    Replies: 3
    Last Post: 06-13-2015, 05:56 AM
  4. Valitation Date fot Trial Version
    By gstylianou in forum Access
    Replies: 2
    Last Post: 12-31-2013, 03:17 PM
  5. connecting to odbc with a trial version
    By tfurubay in forum Access
    Replies: 0
    Last Post: 03-20-2012, 11:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums