I have a VB6/MDB product.
If I want to prevent a client from doing a mass transfer of data out of the MDB into another database, what can I do to the MDB?
The passwords on MDBs can be easily cracked so that is not an option.
Ideally it would be some sort of encryption that can only be decrypted by my product. Are there any ready made solutions to achieve this?
EDIT: I have thought of just encrypting some important data fields, such customer names, ids which would render the database useless. However, this would only be for any data entered in the future.
If you are really worried by this question, then your best option is to upgrade your existing database to ACCDB format used in Access 2007/2010. Then Encrypt with a database password.
The new format uses the Windows Cryptographic API for database encryption. This change augments the level of sophistication required to decrypt the database via brute force attacks.
Moreover you could augment the default encryption key of 40bit following this tutorial