Skip to main content

Error - 'Cannot open database.' Document Export Failed

Updated yesterday

The Access Capture integration service runs on a PC somewhere on the network of your organisation (unless you are an Access Hosted Client, where it'll be running in the Cloud).

Within the service is a set of configuration files. One of these is the Readsoft Broker Service.exe.config

This file holds the connection properties to your Database(s).

The fact you are getting an error such as mentioned in this article is caused by at least one of the Databases in the config file not able to connect.

This could be down to a variety of reasons, some of which (but not all) are below:

  • The Login account User credentials have changed

  • The SQL Server which hosts the Database has moved

  • The Database is offline or has changed name

In order to resolve this issue you will likely need the assistance of your IT (in order to access and update the service config files)

Following the below steps will help you navigate through the Access Capture broker service config. It will not help identify the cause of the error. This may have to be established by an IT professional.

  1. Log on to the PC which hosts the Access Capture Broker Service

    • The Broker Service is a windows service and will appear in the Services.msc of the PC

    • You are looking for a ReadsoftBrokerService which will have the Description Access Readsoft Broker service processes documents from Readsoft Online into Access products

  2. Locate the service using above information and then navigate to the file location of the running service

  3. Once you have located the files for the Broker Service open the file Readsoft Broker Service.exe.config in notepad

  4. Search in the file for <company name="

  5. This will take you to the first 'Database' connection property.

  6. It is nested in the opening <company and closing </company> XML tags

  7. You should also see a <add key="SqlServerName along with other XML tags relating to the Database, Login user credentials.

  8. You should ensure that all the relevant details in the XML tags are correct or updated if invalid.

  9. Once you are sure it's correct save the file (make a backup first if need be)

  10. In order for the changes to take affect you'll need to also restart the service

If you are an Access Hosted Client or are not able to access your Broker Service files, or need assistance - please see the following Get support in Access Capture and reference the title of this article.

Did this answer your question?