How to fix ‘Error accessing file…’ when opening Sage Accounts

How to fix ‘Error accessing file…’ when opening Sage Accounts ?

Emma Asked on December 4, 2017 in Sage.
Add Comment
  • 1 Answer(s)
    Best answer

    Sage 50 is one of the best business management software for both small and mid-size businesses. Power-packed with some of the latest and most advanced industry-specific accounting functions, it can help owners streamline and manage all their essential business operations.

    However, at times, you might run into errors while working on your Sage accounting software. One such error is ‘Error accessing file on the specified data path’. This error message occurs when your Sage accounting software cannot locate the Accdata folder in the specified data path and could appear in any one of the following message forms:

    • Error accessing file on XXX. The system cannot find the path specified.
    • Error accessing file on XXX. Logon failure, unknown username or bad password.
    • Cannot find directory XXX – Please check your Company file and icon properties.

    Here, XXX represents the data path being used.

    How to fix the error

    Though the error message looks quite tricky, the method to fix it is quite simple and can be performed manually. Here’s how you can fix the error message on your own.

    Step 1: Verify the company

    Verify if it is a new company. If not, then click Next.

    However, if it is a new company then,

    1. Locate the company file and click Delete. Now try to open the software again.
    2. If the issue has not been resolved, then try to uninstall and reinstall the software to a new directory.

    Step 2: Check the specified data path

    If the error still persists, then click Next and check if the specified data path is correct:

    1. If the data path starts with C:\ then your data is stored on the local PC.
    2. If the data path starts with \\ then you need to access your data through a network.
    3. If the data path starts with any other letter, then you need check if it is stored on a local network or a network drive. For this, go to Start and click on Computer. Now right-click on the drive letter and check Properties.

    Step 3: Data stored locally

    It is very uncommon for this error to occur if your data is stored locally. However, it can occur if

    • The path in the Company file is wrong.
    • Folders in the data path have been renamed or modified.

    In case, the path in the Company file is incorrect, you need to amend it. For this,

    1. Browse the Company file.
    2. Double click on the Company file and click Open with Notepad.
    3. Amend the path by clicking on File > Save > File > Exit.

    However, if the path specified in the company file is correct, then one of the folders must have been deleted, moved, or modified. In case you are not able to retrieve the folder, create the missing folder manually and restore it back to the Sage account.

    1. Browse the Company file.
    2. Click on File, then click New and go to Folder.
    3. Type the name of the missing folder and click Enter.
    4. Double click on the new folder and click on File, then click New and click Folder.
    5. Type Accdata and press Enter.
    6. Now open your Sage Accounts and complete the ActiveSetup Wizard to create a new company and restore the latest backup.

    Step 4: Data stored on Network

    Check whether your data path starts with \\ or a drive letter.

    When data path starts with \\

    Here, the data is accessed via the UNC path. This could occur due to various reasons like insufficient network permissions, renamed or deleted folder, unavailability of server, or the server being password protected.

    To fix the error message,

    1. Hold the Windows key and press R.
    2. In the box, type the UNC path and check for the error message –
      • Error message ‘Access denied’ means you do not have sufficient permission to access the path. Check with the IT administrator to modify your access rights.
      • Error message ‘The network path was not found’ means either the folder is missing from the path or the server name is incorrect. Ensure that the server name and path are correct.
      • If user ID and password prompt appears, then it means that the password protected sharing is turned on. Turn off the password protected sharing to solve the issue. For this,
        • Click Start and go to the Control Panel.
        • Click Network and Internet and open Network and Sharing Center.
        • Now click on Advanced sharing options and turn off password protected sharing.
        • Click on Save changes and then click Continue to fix the issue.

    When data path starts with a drive letter

    It is not uncommon to lose a network connection if the data is accessed via a mapped network drive. To fix the issue, change the data path to a UNC path. For this,

    1. Browse the Company file and double click on it.
    2. Open it with Notepad.
    3. Now change the Company file to its equivalent UNC paths.
    4. Now click File > Save > File > Exit.

    Following these steps can help you solve ‘Error accessing file on the specified data path’ with your Sage accounting software. However, if you are still not able to fix the issue, you need expert help. Call 1-888-489-0694 to get in touch with a certified Sage repair consultant at Sage Technical Support Phone Number who can help you fix the error message at the comfort of your home or office.

    Support Team Answered on December 4, 2017.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.