Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inactivate a Database (2003)

    I have a database which is for producing reports and one can't add information. I want to allow users to use this database for 3 months then make it inactive because I receive a download of information and reproduce the database. How could I inactivate the database at a certain time in the future?

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inactivate a Database (2003)

    Try setting up a discreet/hidden table with a date in. Check against the date when you open the database and quit if the date has expired. This is not a terribly secure method (even password protecting the date table's database is open to cracking).
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inactivate a Database (2003)

    You could use something like the following"

    This code could be in startup form or autoexec macro

    If my customers don't pay their annual maintenance by due date they get a message

    GetPref are variables in a customer profile table

    HTH, John

    <pre>If Format(CDate(GetPref("System Expire Date")), "yyyymmdd") _
    < Format(Date, "yyyymmdd") Then

    MsgBox GetPref("System Expire Message")

    'MsgBox "Your System Maintenance has Expired - Call Support4John (716) 123-4567"
    DoCmd.Quit
    End If
    </pre>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •