Consulting

Results 1 to 11 of 11

Thread: Advice: Creating a licensing method

  1. #1
    Administrator
    VP-Knowledge Base
    VBAX Master
    Joined
    Jan 2005
    Location
    Porto Alegre - RS - Brasil
    Posts
    1,219
    Location

    Advice: Creating a licensing method

    Hi guys,

    I will sell a workbook and need to limited to the minimum the number of users (I mean unauthorized users ) of it, so I would like suggestions on that.

    My idea is to create a kinda registration module that when the workbook is first opened saves on registry its processor type, processor serial number, HD size, HD serial number, network card MAC, and memory available, converted to a string according to an algorithim. After that it will send this info to a webservice hosted at my site that will save this info in a database and return a code that will let the workbook run during a month.

    If it was opened before it will check that data to the registry and if it matches will send it again.

    If the webservice gets a different string from the computer it will advice me and send a code to close the workbook.

    Any suggestions for better approach?
    Best Regards,

    Carlos Paleo.

    To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.

    If Debugging is harder than writing a program and your code is as good as you can possibly make
    it, then by definition you're not smart enough to debug it.




    http://www.mugrs.org

  2. #2
    Administrator
    Chat VP VBAX Guru johnske's Avatar
    Joined
    Jul 2004
    Location
    Townsville, Australia
    Posts
    2,872
    Location
    Hi Carlos,

    I don't think this is the best approach, it would be so easily done but we're starting to get into the field of 'spyware' and 'trojans' here so I won't even talk about it.

    A more conventional approach is to look at some method of 'registering' it with a registration code.

    As to your suggested method. What if the registered owner puts it on their "other" computer or their laptop - they've perhaps paid for something that can only be used on one particular PC? I don't think that would be very popular.

    Regards,
    John
    You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you

    The major part of getting the right answer lies in asking the right question...


    Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.

  3. #3
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    I have some software which generates an activation code based on the Hard Drive ID. Unfortunately, due to a drive failure, I had to move it to a temporary drive, which required reactivation. Then my new drive came in, (this is a network environment) which required moving the data and reactivating it again.

    The system seems to work, but these guys have a 24 hour customer support to give you an activation key immediately. It's still very frustrating though.

    Having said that, I can think of nothing worse than having my software locked up because my ISP is having an issue...

    I think you'll find that the consensus on this issue is that there is no unbreakable method to do this. If you want legal recourse, make a good EULA.
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





  4. #4
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    You have 2003, yes? Use the new permissions feature. You'll need a database to store your user's information and such, or you can rent space from MS (I believe). That's the best way to go, imho. Or create your own database, do a link to it when opening, checking for user status and that, ensuring you use Strong arm tactics to *force enable* macros. But using VBA for such security measures begs for problems.

  5. #5
    Administrator
    VP-Knowledge Base VBAX Master
    Joined
    Jan 2005
    Location
    Porto Alegre - RS - Brasil
    Posts
    1,219
    Location
    Quote Originally Posted by johnske
    As to your suggested method. What if the registered owner puts it on their "other" computer or their laptop - they've perhaps paid for something that can only be used on one particular PC? I don't think that would be very popular.
    Hi John, this is exactly what I want. I will sell it to run on ONLY one computer, so if you want to install it on your laptop, you must buy another license, also if you upgrade more than one item on your machine you must contact me to still have your software running.

    Quote Originally Posted by kpuls
    Having said that, I can think of nothing worse than having my software locked up because my ISP is having an issue...

    I think you'll find that the consensus on this issue is that there is no unbreakable method to do this. If you want legal recourse, make a good EULA.
    Hi Ken,

    thats why I will keep activated one month without having to connect and of course it will be writen at the EULA the user must access the net at least once a month. Its gonna be selled in Brazil and most people down here dont even read EULAs and they couldnt care less about then. Of course my method CAN be breaked but not by regular excel users.

    Quote Originally Posted by firefytr
    You have 2003, yes? Use the new permissions feature. You'll need a database to store your user's information and such, or you can rent space from MS (I believe). That's the best way to go, imho. Or create your own database, do a link to it when opening, checking for user status and that, ensuring you use Strong arm tactics to *force enable* macros. But using VBA for such security measures begs for problems.

    This approach attracts me very much by a large number of my users for this application dont use nor plan to migrate to 2003, they are still using 97, so I cant do this.
    Best Regards,

    Carlos Paleo.

    To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.

    If Debugging is harder than writing a program and your code is as good as you can possibly make
    it, then by definition you're not smart enough to debug it.




    http://www.mugrs.org

  6. #6
    Administrator
    VP-Knowledge Base VBAX Master
    Joined
    Jan 2005
    Location
    Porto Alegre - RS - Brasil
    Posts
    1,219
    Location
    Any more suggestions? I am a little confused on what should I do so I thank any suggestion.
    Best Regards,

    Carlos Paleo.

    To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.

    If Debugging is harder than writing a program and your code is as good as you can possibly make
    it, then by definition you're not smart enough to debug it.




    http://www.mugrs.org

  7. #7
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Quote Originally Posted by Paleo
    Hi Ken,

    thats why I will keep activated one month without having to connect and of course it will be writen at the EULA the user must access the net at least once a month. Its gonna be selled in Brazil and most people down here dont even read EULAs and they couldnt care less about then.
    Hi Carlos,

    Not really the point, actually. I don't think many users actually do read the EULA. The point is that if you do find someone stealing your software, you have legal recourse to sue them. Just makes the job easier if you need to go there.
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





  8. #8

  9. #9
    Administrator
    VP-Knowledge Base VBAX Master
    Joined
    Jan 2005
    Location
    Porto Alegre - RS - Brasil
    Posts
    1,219
    Location
    Great guys, thanks!

    Now I understood your point Ken, VERY IMPORTANT I agree.

    Thanks Zack, I will check it out!
    Best Regards,

    Carlos Paleo.

    To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.

    If Debugging is harder than writing a program and your code is as good as you can possibly make
    it, then by definition you're not smart enough to debug it.




    http://www.mugrs.org

  10. #10
    MS Excel MVP VBAX Tutor
    Joined
    Mar 2005
    Posts
    246
    Location
    This isn't fancy, but it's more effective than I'd have imagined. This site has an example that writes the starting date to the registry, and after a preset number of days, it stops working. People seem to think that since I'm a professional programmer, and since my program tells them it's not going to work without paying me for the unlocked version, they'd better pay. Of course, corporate clients may not be so warez-aware....

    http://www.andreavb.com/tip080006.html
    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______

  11. #11
    Administrator
    VP-Knowledge Base VBAX Master
    Joined
    Jan 2005
    Location
    Porto Alegre - RS - Brasil
    Posts
    1,219
    Location
    Thanks for the tip Jon! I will use it too.
    Best Regards,

    Carlos Paleo.

    To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.

    If Debugging is harder than writing a program and your code is as good as you can possibly make
    it, then by definition you're not smart enough to debug it.




    http://www.mugrs.org

Posting Permissions

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