I/O error in file Sage 50 Accounting US Edition

I/O error in file Sage 50 Accounting US Edition

Prior to initiating any data recovery procedures, it is imperative to create a recent backup of your company’s data. It is strongly advised not to merely execute the data integrity checks. These processes are quite stringent and may eliminate any data they deem to be incorrect. This could result in the loss of transactions, customer/vendor information, prior period balances, and other crucial data.

When an I/O Error is encountered in Sage 50, it signifies that the software is unable to access the necessary data file. This error typically arises when the connection between a workstation and the database is interrupted. The potential causes for this interruption could be:

  • A power outage
  • Workstation disconnection from the network cable or router
  • Unresponsiveness of the workstation, leading to a user-initiated reboot while Sage 50 was open
  • Any other event that disrupts the connection from the workstation to the database location

In many instances, these issues can be rectified by restarting each computer that utilizes Sage 50 within your network. It is crucial to ensure that all users save their work prior to initiating the reboot.

If the problem persists after rebooting, an error message will indicate which file has been compromised. Typically, the affected files are JrnlHdr.dat, JrnlRow.dat, Vendor.dat, or Customer.dat.

If the I/O error persists, your remaining options are to either restore from a previous backup or utilize our Sage 50 Data Recovery Service for data repair.

Please note, restoring from an older backup may result in significant downtime due to the necessity of reentering transactions, balances, and updating maintenance records. This process can be time-consuming and may disrupt regular operations. It’s important to consider this factor when deciding on the best course of action.

Related Articles

Sage 50 you cannot save these changes

Sage 50 you cannot save these changes

This error may be many different issues. Make sure you are not trying to edit an archived company. You can tell this by looking at the Sage 50 program title bar. Make sure it does not say Archived (company name), you cannot edit an archived company. If you are not...

Unable to determine security privileges Sage 50/Peachtree

Sage 50 and Peachtree Accounting Software - Unable to determine security privileges. Please retry later. This is probably due to another user temporarily blocking access to critical files.This error is caused by damaged .dat files.  It has nothing to do with User...

Sage 50 you cannot save these changes

Sage 50 you cannot save these changes

Sage 50 you cannot save these changes

This error may be many different issues. Make sure you are not trying to edit an archived company. You can tell this by looking at the Sage 50 program title bar. Make sure it does not say Archived (company name), you cannot edit an archived company.

If you are not working with an archived company then your company’s DDF (Data Dictionary Files) may be damaged. The DDF files provide the database schema (database layout) to the Sage 50 database.

You can delete these files and Sage 50 will create a new set for you when you open your company again.

Always backup your company’s data before deleting any files.  We cannot stress this enough.  If you delete the wrong files by error you can easily get them back by restoring your backup. 

Locate your company data folder. If you are running Sage 50 2021 you may find this on the open company dialog. If you are running an older version. Open the company, from the top menu select Maintenance, and select Maintain Company Info.

Once you have your company’s data location at hand, close the Sage 50 program. Make sure any additional users have the company closed as well. The company cannot be in use when we are going to delete the DDF files.

Open Windows File Explorer and navigate to the data folder above.

Delete all the DDF files.

Restart Sage 50 and open the company.  You should see a flash dialog showing that it is recreating the DDF files.

That’s it.  Now see if the message “You cannot save these changes.” has stopped.

Related Articles

Sage 50 you cannot save these changes

Sage 50 you cannot save these changes

This error may be many different issues. Make sure you are not trying to edit an archived company. You can tell this by looking at the Sage 50 program title bar. Make sure it does not say Archived (company name), you cannot edit an archived company. If you are not...

Unable to determine security privileges Sage 50/Peachtree

Sage 50 and Peachtree Accounting Software - Unable to determine security privileges. Please retry later. This is probably due to another user temporarily blocking access to critical files.This error is caused by damaged .dat files.  It has nothing to do with User...

Unable to determine security privileges Sage 50/Peachtree

Unable to determine security privileges Sage 50/Peachtree

Sage 50 and Peachtree Accounting Software – Unable to determine security privileges. Please retry later. This is probably due to another user temporarily blocking access to critical files.

This error is caused by damaged .dat files.  It has nothing to do with User Security or any other user’s rights issues.  Sage 50 or Peachtree is trying to open a file that has been damaged.

The damage is normally caused by:

  • A workstation losing connection to the Company’s database.
  • Workstation lockup or reboot while Sage 50 was open.
  • Network issues that broke the connection to the open database.
    Power failed while using Sage 50 or Peachtree Accounting.
  • This is not a damaged program problem it is a data file problem.

This causes the files to not be properly updated and left in an invalid state. We have found that most of the time that pieces of transactions will be missing and totals will not be updated correctly. It normally affects multiple files and your main transaction files (jrnlhdr.dat and jrnlrow.dat).

There may also be times when the damage could have happened weeks prior and because you have not hit that damaged area within the file and never received the error message. Once you receive the error message you will be unable to continue until it has been resolved.

There are only two options to resolve the problem:

  1. Either restore a backup prior to the damage
  2. Have your Company files repaired by our Data Recovery Service.

If you decide to restore from a prior backup, make sure you run the Data Verification process from the File Menu once the backup is restored. You will also have to reenter any maintenance records and transactions since the timeframe of your backup.

You will need to research why the Security Privileges Error happened.

  • Ask users if they encountered any problems while working in Sage 50.
  • Other applications that may have caused the workstation to lock or reboot.
  • Check Windows Application and Services Logs in the Control Panel for Events.
  • Check your network wiring and patch cables.
  • If your environment has power surges or drops, install an Uninterruptible Power Supply (UPS) to all workstations including the File Server (if used).

Related Articles

Sage 50 you cannot save these changes

Sage 50 you cannot save these changes

This error may be many different issues. Make sure you are not trying to edit an archived company. You can tell this by looking at the Sage 50 program title bar. Make sure it does not say Archived (company name), you cannot edit an archived company. If you are not...

Unable to determine security privileges Sage 50/Peachtree

Sage 50 and Peachtree Accounting Software - Unable to determine security privileges. Please retry later. This is probably due to another user temporarily blocking access to critical files.This error is caused by damaged .dat files.  It has nothing to do with User...

At least one damaged transaction has been found in account [Account ID] in the period beginning

At least one damaged transaction has been found in account [Account ID] in the period beginning

This Sage 50 error message notifies you that there are damaged transactions.

  • If the beginning period is within the current 2 open years, Data Verification should fix it.
  • If the period is outside of your open 2 years your data will have to be repaired using our Sage 50 Data Repair Service. This is because Sages 50 Data Verification option only works the 2 open years of data.

You will receive the error message while running a General Ledger report. The error may not appear until you select a range of periods to report.  If you run your report by Date Range it will not show you any errors.

Running Sage 50 Data Verification

  1. From the top menu select File and then Data Verification.
  2. Select Both Tests, and then click Start.
  3. Enter a New Backup File Name. Never overwrite an existing backup file.  Always name your backup file to something that is useful and unique. If you run Data Verification multiple times always give the backup file name a different name. Data Verification will start automatically after the backup has completed.
  4. After the process has finished run a General Ledger report (with a large period range) to see if you still receive the error.

If you still receive the error you will need to submit your data for our Data Recovery Service.

Related Articles

Sage 50 you cannot save these changes

Sage 50 you cannot save these changes

This error may be many different issues. Make sure you are not trying to edit an archived company. You can tell this by looking at the Sage 50 program title bar. Make sure it does not say Archived (company name), you cannot edit an archived company. If you are not...

Unable to determine security privileges Sage 50/Peachtree

Sage 50 and Peachtree Accounting Software - Unable to determine security privileges. Please retry later. This is probably due to another user temporarily blocking access to critical files.This error is caused by damaged .dat files.  It has nothing to do with User...