secure the database & query design

[Jimal]

Hello savior over there

I have done a project and with our forums lots of support I was able to complete it

But now I have a challenge before me- how to protect the project so that its source programming/query designs could not be revealed to others.

As simple I would like to LOCK my backend design - appreciate if you can put in some of your thoughts..

Thanks in advance

 

[Jimal]

yes @Pat Hartman

I agree with you. at the same time I don't want my 1 year hardwork exploited easily.... you can relate my concern with a kind of "Stolen intellectual property"

 

[CJ_London]

so you are not concerned about securing your data?

to protect code, forms and reports, create a .accde

to protect queries, more difficult. Probably the best way is to not have them as separate objects, Instead store the sql in your code and execute/openrecordset as required and/or store the sql in the form/report recordsource.

Note this is only a base level security - someone who knows what they are doing can still find ways of finding out your sql and there are sites out there who claim to be able to reverse engineer a .accde

 

[isladogs]

Although as already noted, you can never make an Access application totally secure, there are several things you can do to make it as secure as possible.
See my two part article: Improve security in Access databases.

 

[theDBguy]

yes @Pat Hartman

I agree with you. at the same time I don't want my 1 year hardwork exploited easily.... you can relate my concern with a kind of "Stolen intellectual property"

Hi. Unfortunately, you are using a platform that wasn't intended to be totally secured. So, although there are plenty of ways to try and secure your work, none of them is totally fool proof. Good luck!