Results 1 to 6 of 6
  1. #1
    Mclaren is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164

    Random Text and Numbers

    I want to know if there is a way to create a random sequence of letters and numbers. In addition i want to encrypt the result or convert it to a number, so that i can perform a calculation on it and return a unique number that will be used as an unlock code.



    In essence i want :

    RH6766759NJCQ900W this must then be converted to a number i.e: 685126487562344785 which i can then do a calculation on to create another number.

    this is to be used as an anti copy system to my DB.

  2. #2
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    there are better ways to prevent copying your work aside from this, I would think. But take a look at this for randomization: http://www.ajenterprisesonline.com/_...e=KeyGenerator

    that might get you started with ideas of how to randomize a piece of data, numerical of not. I don't know much about the encryption side of it. maybe other software?

  3. #3
    Mclaren is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    Quote Originally Posted by ajetrumpet View Post
    there are better ways to prevent copying your work aside from this, I would think.

    Suggestions.....

    My main aim is to prevent a person from installing on more than one machine on any given network.

    My DB is very basic and if the company i am writing it for likes it, i want them to purchase additional copies, and not just use one accross several pc's

  4. #4
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you might want to purchase a more advanced packager then. there are ways to authenticate software for one time use only, but I've only done it once, and through DOS only.

    The method I used was not very good because compatibility issues were common. However, it did work and I was able to prevent unauthorized copies.

    Another method I've used is the combination of vba code and internet webpages, along with an installation key to validate the installation. You can use a variety of methods to require the user to log on to a webpage, or direct them to it via some vba script and check the key in a server database, or if that is not possible, you can even check it against a text file log sitting on the server.

  5. #5
    Mclaren is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    What will be happening is the random code, the unlock key etc will be stored in the users front end and in the back end by updating a module with the values.

    Each time a PC fires up the application, the front end to checks the code and redoes the calculation ensuring the application is being launched from the same PC, it will then check the codes on the PC to the codes on the back end, so kind of like a double check, if the user manages to tamper with the front end, the back end will not match, and a warning of irregularity will be issued.

    i have got everything working fine, its just the conversion of the random code to a number that i need to do so i can perform a calculation.

    this step is required so that a new installation has to be confirmed by myself and i send the unlock code to them. right now i have managed to get the random code down to ASC, but i cannot seem to perform calculations on it, it is all numbers but it is in string format, so i need to convert it to numbers.

    I have seen Peters Software version that does what i need, but its a bit pricey at $299. Just for one use.

  6. #6
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    906
    Hi,

    just a thought here: I'm rather a fan of open source software, so I really never protect my code. In most projects I even teach some power users how they can alter the software themselves. I found that people rather pay for expertise then for lines of code, and that they rather rehire me than some collegues who protect their applications.
    For the few really closed apps I have written, I have chosen a different, not so widely known, platform than Access (Omnis Studio or so)

    grNG

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

Similar Threads

  1. Convert text to numbers
    By Mclaren in forum Programming
    Replies: 2
    Last Post: 05-02-2010, 01:36 PM
  2. Convert text to numbers
    By randolphoralph in forum Access
    Replies: 1
    Last Post: 03-21-2010, 10:33 AM
  3. Replies: 2
    Last Post: 09-10-2009, 05:42 AM
  4. Random numbers
    By Gator777 in forum Access
    Replies: 3
    Last Post: 08-12-2009, 10:04 AM
  5. generating random numbers on form
    By anitra in forum Forms
    Replies: 1
    Last Post: 02-14-2006, 10:08 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