Results 1 to 3 of 3
  1. #1
    gstylianou is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Dec 2013
    Posts
    166

    Valitation Date fot Trial Version

    Helo to everyone,

    I have a database which i need to create code so that after the installation date of the database, then after 30 days the database must close automatically and ask for admin code. Unfortunately I am a beginner in vba so I can not write the code. I'll be grateful if any forum member can help



    Thanks in advanced

    Regards

    George.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,046
    Unless you publish the database as an executable, this feature would be virtually meaningless. Holding down the shift key while opening mdb or accdb will override most optional settings and bypass automatic code execution. The database is then fully accessible.

    First, the 'install' procedure would have to record a date in a table. Then code in an autoexec macro (a macro that executes as soon as the db is opened) or code behind a form that opens by default when the db opens would calculate difference between that date and current date and act appropriately.

    This assumes the database is regularly closed and not left perpetually open.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    You could take it a step further and have your app Ringdown POP-CORN to verify the date. The system time could possibly be overriden by the user.

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

Similar Threads

  1. MSAccess 2007/2010 Date Picker Replacement - Version 3
    By pkstormy in forum Code Repository
    Replies: 8
    Last Post: 10-06-2015, 05:39 AM
  2. Replies: 3
    Last Post: 02-04-2013, 05:24 PM
  3. Replies: 4
    Last Post: 05-30-2012, 07:00 AM
  4. Replies: 5
    Last Post: 01-18-2012, 12:46 PM
  5. Access trial
    By David.T in forum Access
    Replies: 2
    Last Post: 04-08-2010, 04:15 PM

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