protect access database 3

[earlrainer]

Hi,

I have a Access database with contents I want to protect .

what are the means by which I can protect my database , so that no one can open the database and view\copy the contents.

 

[jrbarnett]

What do you want to protect? Is it the source code or the entire database?

If the former, then you can use an MDE file to stop people accessing the code, but they can still access the compiled forms/reports/VBA routines.
If it is the entire database, then I suggest a third party encryption product to encrypt the whole MDB file, of which there are many.

John

 

[earlrainer]

I have a program in delphi which uses a Access database as the back end.
the database contains information that has been collected using years of effort ,and thats why it should not go into wrong hands.

most access database files *.mdb , you can simply open .
I want to prevent things like this

 

[JeremyNYC]

You'll have to read the access security faq. THere's a copy on my website or you can get it from MS.

But you'll also need to know that no security you can apply to an mdb will be particularly secure--if a hacker wants in he'll get in in short order. If you need to protect a business investment by protecting your data, you'll need to use something other than access. If you just want to make it difficult for someone to stumble onto your data, or slow down someone who's just poking around for the heck of it, Access will do the job. But not if you're trying to stop someone with bad intentions.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[LittleSmudge]

Read up on the Access Security Model in MSAccess Help.

That will get Access as secure as any other option available.

THEN convert it to a .mde file to lock it down even further.





G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[jrbarnett]

A quick thought:
If the database is being used purely for storage, put one dummy form in and set it as the startup.
On this form in the Form_Open event put the following code:

MsgBox "This database is used by application X and should not be opened with Microsoft Access. Please use application X for all data access with this database", vbOkOnly+vbCritical
Application.Quit

then when they open the database with access, it will display this message and quit when they hit the OK button. Then disable the AllowByPassKey property to stop people opening it with shift and convert it to an MDE file (Delphi should have no problems with this).
Danvlas here has posted a method of getting around the AllowBypassKey property, but this method will stop 99.9% of all known users opening it directly.

Another enhancement of course would be to encrypt the table contents from within the delphi program (and ensure the routines are kept within the delphi source code), so that even if anyone gets hold of the file, they can't access the data from within Excel or linked tables in another access database.

John

 

[earlrainer]

Thank you Guys