Question Building Security system for Access Database

[Gasman]

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

 

[isladogs]

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

       'Access 2007
        Case "12.0.0000.0" To "12.0.5999.9999": GetAccessEXEVersion = "Access 2007 " & sAccessVerNo & ""
        Case "12.0.6211.0" To "12.0.6422.9999": GetAccessEXEVersion = "Access 2007 SP1 " & sAccessVerNo & ""
        Case "12.0.6423.0" To "12.0.[B][COLOR="Red"]5[/COLOR][/B]999.9999": GetAccessEXEVersion = "Access 2007 SP2 " & sAccessVerNo & ""

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.

 

[Gasman]

Options shows (12.0.6735.5000) SP3 MSO (12.0.6802.5000)

 

[isladogs]

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

 

[alvingenius]

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

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

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

 

[arnelgp]

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

 

[Gasman]

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

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.?

 

[alvingenius]

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

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

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.?

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

 

[Dick7Access]

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.

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.

 

[Deleted member 147267]

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

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.