Error: 'Microsoft Access database engine cannot find the input table' after updating to the latest version

This solution provides steps to resolving the error message 'The Microsoft Access database engine cannot find the input table or query 'XXX'. Make sure it exists and its name is spelt correctly'. The resolution will differ if you are running Chintaro on MSAccess and SQL Server.

If you use Microsoft Access to run Chintaro

If you have received the error 'Microsoft Access database engine cannot find the input table' after updating your version, please ask all users to completely log out.

Once all users have completely logged out, you will need to reset the update version by going to System Maintenance> Reference Tables> Parameters, and scroll down until you get to 'UpdateVersion' in the Parm column.

Remove the number in the Parm Number column and replace with 6000.

Close Chintaro and re-open again. 

If the issue still persists, please ensure the Trusted Locations are enabled in MS Access.

Open Microsoft Access and click

Clickand then Click

Click

Tick the ‘Allow Trusted Locations on my network’ box:

Click

Add the Chintaro Data folder and the local Chintaro client folder to the Path field:

If you use SQL Server Management Studio to run Chintaro

If you have received the error 'Microsoft Access database engine cannot find the input table' after updating your version, please ask all users to completely log out. 

Once all users are logged out, re-run the scripts from the patch zip file in SQL Server Management Studio.

Open Chintaro.

If the issue still persists, please ensure the Trusted Locations are enabled in MS Access.

Open Microsoft Access and click

Clickand then Click

Click

Tick the ‘Allow Trusted Locations on my network’ box:

Click

Add the Chintaro Data folder and the local Chintaro client folder to the Path field:

For further assistance with this error message

Please contact support@chintaro.com.au advising the steps you have taken to resolve the issue.