I have an access2000 aplication with security implemented, used on a server.
I saw a program which hack the mdw workgroup file...and then anyone can see the users defined in mdw file, and the correspounding passwords. S, anyone can login with the administrator rights into the database...which can be very bad!!!!
Is there any posibility to encrypt the mdw file????
I do not think that you can with the encryption util in access.
I believe there are other 3rd party vendors to encrypt but then they will have to invoked prior to access loading and looking at the mdw file
What application is that you saw that looks at the PID and Password for the mdw - I was under the impresion that this was encrypted as well
you can use notepad to view the mdw file (users only) but PID, password and other data is encrypted (i think)
Unfortunately...this application exists...and yes, the passwords are encrypted, but this program decripted them.
I tried to encrypt...or something (I thought like double encrypt or another encryption algoritm...) with the function from Tools->Security->Encrypt/Decrypt. But...it does not solve the problem. The passwords can be still founded.
And..as the mdw file must be accessible to everyone...
I can see no other solution but to write a VB application...which to connect to the access db...and handle the data. This is the only safe method I can find. And users and security to be implemented in VB modules. It is just a lot of work to be done!