We know it is very time-consuming and difficult to troubleshoot sage-related issues, we try our best to update the content regarding sage. Recently we had to troubleshoot Sage's payroll-related issue where finally the issue was resolved by the following steps.
PAY: OPEN sgtbl_AccessRights Recordset open failed.
Pay: OPEN payroll tasks sgtbl_payrolltasks_users recordset open failed.
To rectify both, please follow the steps below
Close down Sage and if you receive any other error just press OK
Then browse to the sage installation folder, e.g. C:\Program Files\Sage Payroll
Run the following program: Dbutilities.exe
Then Select the appropriate company database by left clicking on it so that it is highlighted.
Then choose: “Clear Locks”
Then when that completes (usually in seconds) choose: Repair
Do you need help to install or troubleshoot Sage 50cloud Payroll?
Call : 0333 888 0241 @: email@example.com
IT Support London , IT Support for Accountants London, IT Support for accounting firms, Sage payroll IT Support London, IT Support for Sage London , IT Services for Accounting firms, IT Support for Small Businesses London, Troubleshooting Sage