The data should be accessed without requiring a login. How to clear user locks in Sage PayrollĬlick OK. If the password contains spaces, it must be changed in User Maintenance. Note: Do not use spaces or blanks in the password name. Enter the database directory location this is the path to the.Įntering the company code in lower case may cause the silent ODBC connection to fail. Do not use spaces or blanks in the data source name. Resolution Note: This procedure may or may not work on any given operating system. If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.

This can be used with Report style access but should not be used for interactive access. When the application executes a SQL command then fetches a row, the physical data file will remain locked until at least 20 rows have been fetched or EOF. The ODBC driver will apply short-term locks to improve performance between data fetch commands. In practice this is not likely to happen. In theory, an update could occur while the query is in progress and may be missed. Assistance by a qualified computer technician may be necessary. Sage Software Customer Support is not responsible for assisting with this procedure. Note: This procedure may or may not work on any given operating system. Please contact your Sage business partner, network administrator, or accountant for assistance. Support Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Always create a backup of your data before proceeding with advanced solutions. Sage is not responsible for operation issues caused by incorrectly modifying your Windows Registry. Modifying your Windows Registry incorrectly can severely affect system operations. Contact your system administrator for assistance.

Does it cost to install zinstall winwin