Question Building Security system for Access Database (1 Viewer)

arnelgp said:

is that so?
anyway, just combine whatever text you get from hd+motherboard+cpu.
then try the db on another pc to chk if the security will work.

Click to expand...

That's also what I do then use elements of each to create an activation ID which is supplied by me during activation then checked against the PC.

As many PCs have multiple hard drives, I use the drive containing the Windows partition. Of course, users may replace their hard drive which may trigger the need for reactivation depending on how the code is designed. That does tend to irritate end users.
Also, as already observed, the HD number isn't always returned so I use a default for that if necessary. However CPU and motherboard IDs do get returned reliably in my experience.

If anyone is interested I have an example app for obtaining detailed system info including the above items and much more http://www.mendipdatasystems.co.uk/detailed-system-info/4594420635

Colin,
Strangely enough that shows all correct info except for my Access 2007 version, though the bitness is correct.?

It states
Access - Unknown Version 32-bit

Although most of the info is obtained using WMI, that part depends on function GetAccessEXEVersion in modSysInfo.
You may have a version number higher than that listed. I've also found an error for A2007 which currently reads
That '5' is a typo. Probably should be a '6' i.e. 12.0.6999.9999.
Can you please check and let me know your version number and SP number.

Options shows (12.0.6735.5000) SP3 MSO (12.0.6802.5000)

Thanks. I'll modify the function in the near future to fix the error and add SP3.

mainly you don't want to be forever fixing it because of anyone meddling where they don't belong.

Click to expand...

@Micron,
No user would EVER be working with the master copy of the database. Each user would have his own personal copy and a new version would be distributed whenever the master was changed. If a user modified his own copy of the FE, it would never affect any other user and it would be clear who made the modification.

That doesn't mean that you shouldn't protect the user from himself and lock down the database to prevent accidents. But unless I were selling the app (and I have apps that I sell), the lock down would be superficial at best.

Thanks guys for your response

i hoped that i get activation or registration system with validation ways u offered

validation only is not enough because maybe the user changes his pc to a laptop or maybe he changed his HD or MB

with validation it must be activation process with generating random numbers and activation keys

isladogs said:

I do have an activation process which I use in some of my commercial apps. However, for fairly obvious reasons I'm not going to give away the code I use for that. In your own words

Click to expand...

something like this, even if it commercial app i want a activation process for customers , they give me the ID shown in app and i transfer this id to activation key to use it

see this thread if it is relevant to you.
https://access-programmers.co.uk/forums/showthread.php?t=305923&page=2

alvingenius said:

Thanks guys for your response

i hoped that i get activation or registration system with validation ways u offered

validation only is not enough because maybe the user changes his pc to a laptop or maybe he changed his HD or MB

with validation it must be activation process with generating random numbers and activation keys



something like this, even if it commercial app i want a activation process for customers , they give me the ID shown in app and i transfer this id to activation key to use it

Click to expand...

If the user was to do that, could you not have an option for 'Request Activation' using the registered email address and some of that data.?

I've had it in the past where I have had to contact a developer for an activation key, as I have changed PC and could not find the old one, from my registered email address?

Your request activation could supply this data from the new pc and then you supply that back as the activation key, with code to insert it for the user.?

TBH if you are having problems with code that enables/disables controls, this is going to be even more complicated I would have thought.?

arnelgp said:

see this thread if it is relevant to you.
https://access-programmers.co.uk/forums/showthread.php?t=305923&page=2

Click to expand...

after revising your db attached in this post

that's a great one and very similar to what i'm asking
but serials is already on the table

and u can easily run the app out of work without asking for license again if i have the last license

Gasman said:

If the user was to do that, could you not have an option for 'Request Activation' using the registered email address and some of that data.?

I've had it in the past where I have had to contact a developer for an activation key, as I have changed PC and could not find the old one, from my registered email address?

Your request activation could supply this data from the new pc and then you supply that back as the activation key, with code to insert it for the user.?

TBH if you are having problems with code that enables/disables controls, this is going to be even more complicated I would have thought.?

Click to expand...

My Idea that i wanna convert to a working code is

A form generating random numbers and letters from 0 to 9 and A to Z named : "product id" lets say : 1A2B3C4D
and the activation key is generated from this ID it self with complex formula and the form that generate in activation key will be with me or ( Developer )

for that customer will give me product id via email and i'll mail back activation key

then this activation key and product id will be saved in client DB table and we can generate a .txt or .ini file with the activation key in client HD in C:/Windows folder ( for example )
and when the client changes his Windows the app will check for the txt file if it exists with activation inside

it will apply too if the client to run the app in another pc it will check for the file, if not exist it will show up a new Product ID

i Hope you get my idea, i'm kinda business analyst not a developer but i can manage to build apps.

PS for @Gasman:
i've created a fully functional Archiving app Using Access while my knowledge in programming Is Null (lol )
but i've managed to do that with your help, with seeing examples here.
and if a new idea came up to me i will run to this great forum to search for it or ask here
controlling a group of controls is something new to me i never used before

Pat Hartman said:

If you built this app for payment, either as an employee or a consultant, I think you will find that according to the law, the app isn't yours at all. It belongs to the people who paid for it. Unless you have a contract signed by them that gives you ownership.

Click to expand...

Pat,
If Doc Man is correct I may owe you an apology. Back a few years ago when you were helping me with some complicated code I always thought of you as male. In fact on one of your visits south I offered your my home, as I have done with others. Rest assured nothing was inferred. Now of course Doc man could be wrong, but one thing for sure, he knows his restaurants. BTW Doc man Lord I am coming back thru in December.

Pat Hartman said:

@Micron,
No user would EVER be working with the master copy of the database.

Click to expand...

Never said that they would be. I DID say there was no mention that the distributed db was an accde, meaning more prone to meddling if not.

@Micron,
Distribution as an .accde solves some of the problems since it protects objects with code.

@Dick,
Not being a snowflake, I ton't take offense easily. No harm, no foul. Maybe we talked about getting together when I was commuting to Birmingham, Al from Stratford, CT every Monday morning (I do NOT recommend this to anyone although the gig did pay very well). The trip "only" took 7 hours on Monday but on Friday it was closer to 9 with all the traffic on 95 and delays at the airport and it cost the client $1200 per week in airfare because I refused to take anything but a direct flight and they were't sure how long the job would take (3 months of every week plus 1 trip a month for 3 more) so they didn't want to book ahead. But, they were a bank and banks have lots of money. My Amex bill was running close to $10,000 per month in expenses. They were very prompt about paying though.

@alvingenius,
I don't have an example of the type of code you are looking for that generates a token tied to hardware but I have seen them advertised. I think one of the companies that sells installation products offers it. Try SamLogic