locked
How can I make a Key Generator RRS feed

  • Question

  • Assalam-o-Alaikum

    I am selling a Access 2007 application and I want to make key generator. Basically a lock like other applications. when I enter the key it will unlock the software upto a specifc date I will chose in the key generator...

    A response will be highly appreciated...

    Thank you...

    • Changed type Wasif Shahid Wednesday, September 1, 2010 9:27 PM
    Wednesday, September 1, 2010 9:23 PM

Answers

All replies

  • Wasif,

     

    you might try checking out an existing product solution like this:

    http://www.sharewarejunction.com/info97114.htm

    (not that I have any experience with this application)

    • Marked as answer by Wasif Shahid Thursday, September 2, 2010 5:23 PM
    Wednesday, September 1, 2010 10:17 PM
  • How to build an application is beyond a simple forum post. However, MVP Tony shares his ideas here:
     

    Copy protection or how to safely distribute a demo Microsoft Access Application

     

    --
    Albert D. Kallal  (Access MVP)
    Edmonton, Alberta Canada
    Pleasenospam_kallal@msn.com
    • Marked as answer by Wasif Shahid Thursday, September 2, 2010 5:23 PM
    Wednesday, September 1, 2010 10:53 PM
  • There is a sample database on Rogers Access Library that uses a key.

    http://www.rogersaccesslibrary.com/forum/licenselock_topic79.html


    Jeanette Cunningham (Access MVP) Pakenham, Victoria Australia
    • Marked as answer by Wasif Shahid Thursday, September 2, 2010 5:23 PM
    Thursday, September 2, 2010 12:16 AM
  • Thank you all you guys I really appreciate it... you guys are really helpful....!

    Thursday, September 2, 2010 5:21 PM
  • Salam,

    Jeanette this link is really helpful... but I am facing a problem that it is for office XP or 2K but the I am using 2007 version and when I apply it on this PC it is showing error.....! I mean is there anything else for 2007 version of Access?

    Thanking You,

    A response will be appreciated....!

    Sunday, December 5, 2010 11:26 AM
  • I have used this solution for A2007. I know I had to update the code for A2007. From memory the troublesome bit was where the code created an accde. Anyway I didn't bother using the code to create the accde, I just did that bit manually.
    Jeanette Cunningham (Access MVP) Pakenham, Victoria Australia
    Sunday, December 5, 2010 8:25 PM
  • Hey I tried to change the code for A2010 I mean I wanted to make the file from accdb to accde. can you help me with this:

      Dim Fpm As String
      Dim acp As Access.Application
        
      Fn_Makemde = 0 ' Default Value
      
      ' Get Path Of Proposed .mde File
      Fpm = Left(Fpt, InStrRev(Fpt, ".")) & "mde"
      
      ' Create new instance of Access application
      Set acp = New Access.Application
      
      ' Convert source mdb file (Fpt) to destn mde (Fpm)
      acp.SysCmd 603, Fpt, Fpm
      
      ' Verify creation of target file (Full path = Fpm)
      If Fn_FileExists(Fpm) Then
        Fn_Makemde = 1
      End If
    
    

    Actually Syscmd 603 only works for previous versions of Access and I need it for 2010....!

    Please Help me...!

    Friday, December 17, 2010 10:19 AM
  • Thanks for asking that question. 
    Dennis Solis
    Friday, December 17, 2010 1:42 PM
  • acSysCmd 603 is undocumented. I can't find anywhere that it is possible to do the same thing in the new accdb format that came out in A2007.
    Jeanette Cunningham
    Saturday, December 18, 2010 4:26 AM
  • "Wasif Shahid" wrote in message
    news:f5cb44e1-1856-4e04-af63-9a9d26f99c99@communitybridge.codeplex.com...
    > Hey I tried to change the code for A2010 I mean I wanted to make the file
    > from accdb to accde. can you help me with this:
    >
    >  Dim Fpm As String
    >  Dim acp As Access.Application
    >
    >  Fn_Makemde = 0 ' Default Value
    >
    >  ' Get Path Of Proposed .mde File
    >  Fpm = Left(Fpt, InStrRev(Fpt, ".")) & "mde"
    >
    >  ' Create new instance of Access application
    >  Set acp = New Access.Application
    >
    >  ' Convert source mdb file (Fpt) to destn mde (Fpm)
    >  acp.SysCmd 603, Fpt, Fpm
    >
    >  ' Verify creation of target file (Full path = Fpm)
    >  If Fn_FileExists(Fpm) Then
    >    Fn_Makemde = 1
    >  End If
    >
    > Actually Syscmd 603 only works for previous versions of Access and I need
    > it for 2010....!
    >
    > Please Help me...!
     
    I haven't tried it and haven't tested it.  But searching the web returns
    links that suggest that maybe SysCmd 603 can work to create an ACCDE, *if*
    preceded by a statement setting automation security to low for the Access
    application.  You'll also need to change the code to specify the "accde"
    suffix instead of "mde".  The relevant bits would be:
        ' ...
        ' Get Path Of Proposed .mde File
       Fpm = Left(Fpt, InStrRev(Fpt, ".")) & "accde"
        ' ...
        acp.AutomationSecurity = msoAutomationSecurityLow
       ' Convert source mdb file (Fpt) to destn mde (Fpm)
      acp.SysCmd 603, Fpt, Fpm
     
    The constant msoAutomationSecurityLow would be defined by the Office
    library, but I think its value is 1, if you don't want to reference that
    library.
     
    As I said, I have not tried this, but I do see some posts suggesting it may
    work.  See, for example, this thread:
     
     

    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html
    Saturday, December 18, 2010 7:02 AM
  • Thank you....! I am trying but not working for now... I ll check the code again.......!

    Thanks Buddy.

    Sunday, December 19, 2010 9:28 AM