IMPORTANT NOTICE: As of 21 February, anything posted in this community WILL NOT BE MIGRATED to our new community site. We have pulled all user information and data from this site and are now in an approximately week long process of importing users, roles, and data to our new site. We are leaving this site open and active so you can post and hopefully get a response until the migration is complete. Once complete, the URL that currently takes you to this site will take you to our new site so your bookmarks will work as always. Please read the information on a New Login Process
When trying to open a worksheet channel in Revolve Enterprise Edition, the following error is encountered.
Unable to open the work sheet due to the following error -
Unable to initialise DAO/Jet db engine
How can this be avoided...?
The solution to this, is to create a new worksheet from scratch.
There are four steps to this:
1) Replace tps\Config\Enterprise\Settings\Defaults\Settings.MDB with a 'known good' version from another system (reinstalling the product should achieve the same result).
2) Go to the Enterprise subdirectory of the project and move out of the directory any .MDB files found there.
3) Temporarily disable any antivirus/antispyware/firewall products on the PC (if only Windows firewall is installed, it's OK to leave this).
Although Micro Focus are not aware of any such product interfering with Revolve (other than with line-of-code metering and licensing, which can be impacted by firewalls), the safest approach is to remove them from consideration.
4) Restart Revolve EE and try to create a new worksheet.