Got an interesting issue that's turning out to be a real head scratcher for us here. We work out of several different solutions at the same time. Every few weeks when working the PO system then switching to our job tracking the program will ask for a password despite already being logged in. After entering the password there is an error message about failed encryption but then the database will open. However once a user starts viewing records they appear with every field completely blank. When searching for these records they still appear so the data is intact but the fields always show blank. So for every record that user then views the data is for all intents and purposes lost and we have to roll back to recover it.
It's gotten quite frustrating as we don't know what's causing the issue and we can lose an entire day's work in job tracking if it happens at the end of the day. This has happened about 3 times now