System Force I.T.

OPEN sgtbl_AccessRights Recordset open failed. Sage Payroll

We at System Force I.T. encountered the following error  on one of our customer’s systems when upgrading to Payroll Year End 2011: Having made a FULL BACKUP of Sage Payroll prior to starting the installation (as you should always do)  we were not too concerned about the error, but wanted a quick fix.

 After installation, and the following reboot, when first logging in to sage after selecting the appropriate company and trying to login, this error appears:

PAY5: OPEN sgtbl_AccessRights Recordset open failed.

To rectify this, we were instructed to close down sage (by clicking ok to any further errors that came up, then logging off and closing the sage window)

Then browse to the sage installation folder, eg. C:Program FilesSagePayroll

Run the following program:


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:


Upon completion of the repair (can take several minutes) close dbutilities.exe, re-open sage, Make another FULL BACKUP (with a different name) and the problem should be resolved.

Tel (Sales) 0845 862 0066
Tel (Support) 0845 862 0077
Fax 0845 862 0044 

View our new Brochure online now Visit Our online Shop = for all your I.T. Hardware needs