Access 2000 database security -


I am developing Windows applications with databases in 2000. Since, I have always been in development, I have some knowledge about safety database. And now, it's time for me to know and have difficulty.

The database is located in shared shared space on our network server. I would like to know how to secure the database so that no one can open the location and still read and write the data through the application of windows Be able to

If you want data protection, then you have something in the form of your data store in addition to Jet / AC Should use.

The last sentence of your question is not quite clear, but it seems contradictory to be able to edit the Jet / ACE database, the user should be allowed to make full changes to the database in the file system. There is no way around it.

Of course if you use MDB format, you can use Jet user-level protection, but it has been broken a long time and it takes about 10 minutes for Google And solve it you can buy. It is also hard to fret and to do it correctly (many people are known through the speed of acquiring their database with Jet Ulse and nothing ends up, but making things more complicated Happened, except to leave it open).

Database Password Protection Theater, however, encryption from the A2007 format is very strong (and not yet easily breakable) in the ACCDF format. But then you have to encode the password in your front-end application, and unless you do not know what you are doing, it is an open invitation to browse with the hex editor to find the password.

If you need protection, a server database increases back end which provides real data protection.

Comments