UltraLite Embedded SQL User's Guide
  Adding Non Data Access Features to UltraLite Applications
    Configuring and managing database storage
      Encrypting UltraLite databases

Changing the encryption key for a database

You can change the encryption key for a database. The application must already be connected to the database using the existing key before the change can be made.

Caution    When the key is changed, every row in the database is decrypted using the old key and re-encrypted using the new key. This operation is unrecoverable. If the application is interrupted part-way through, the database is invalid and cannot be accessed. A new one must be created.

To change the encryption key on an UltraLite database

1. Call the ULChangeEncryptionKey function, supplying the new key as an argument.

   The application must already be connected to the database using the old key before this function is called.

   For more information, see ULChangeEncryptionKey function.