Home Quicken for Windows Errors and Troubleshooting (Windows)

Accounts Show N/A

Several of my accounts now show in the Account List as N/A. I searched for this issue and it seems many have experienced the same. I also see that restoring a backup from prior to the issue is apparently the only fix. I have backups, but typically overwrite my most recent, so I don't have a backup that will solve this problem. Are there any other solutions? This seems like it would be a database corruption error. When I try to correct the account name from N/A to what it should be, I get the error that the account name is already in use. Any suggestions?

Answers

  • Quicken AnjaQuicken Anja Moderator mod
    Hello @JBStewart,

    Thank you for reaching out to the Community to tell us about your issue, though I apologize that you are experiencing this.

    We would normally recommend restoring a backup file, yes. However, if you do not have a backup available to try and restore then, the first thing that I suggest you try is to validate your data file by following the steps below--
    1. First Save a backup of your data file (just in case) 
    2. Go to File
    3. File Operations
    4. Validate and Repair
    5. Validate File
    6. Ok
    7. Close the data log that will pop-up after the validation has completed
    8. Close Quicken
    9. Wait at least 5 seconds
    10. Reopen Quicken
    11. Try again to see if the issue reoccurs/remains the same or gets corrected
    You can also try super validating which are the same steps as above except that you will hold Ctrl and Shift on your keyboard when clicking on Validate and Repair in order to get the option for Super Validate.

    Let us know how it goes!
    -Quicken Anja
  • JBStewartJBStewart Member
    I tried the Validate and Repair as well as the Super Validate as instructed. Neither of those solved the issue. I performed a system restart and did the same procedures again, still to no resolution. Is my only option at this point to start a new Quicken File and begin anew with all of my accounts? My current Quicken File has accounts and transactions that date back to 1996.
  • Quicken AnjaQuicken Anja Moderator mod
    Thank you for the update.

    Before resorting to a new file, I first recommend that you create a copy of your data file by following the instructions provided below in an attempt to rebuild all of the internal lists and database tables.
    1. Go to File
    2. File Operations
    3. Copy...
    4. Leave the presets as is and click OK
    5. Wait for the copy procedure to complete
    6. Select New copy and click OK  


    Note: When choosing Copy..., you will have the option to choose a date range. Since you mentioned your data dates back to 1996, you can see if shrinking the data file by shortening the date range for the copied file will help, if you're comfortable doing so. Your original data file will not be affected by doing this.

    Once the newly copied file opens, see if the issue persists or resolves. If it does persist, please, try validating and super validating again.
    -Quicken Anja
  • JBStewartJBStewart Member
    Tried this procedure. First time with default options including dates, which had the transaction range back to 1996. Received the message "File NOT Copied." Repeated procedure changing date range to 1/1/2010 to current. Received the same message. Since the copy failed both times, I obviously never reached the point of opening the file as directed in Step 6 above.
  • Quicken AnjaQuicken Anja Moderator mod
    Thank you for trying that, though I apologize that that did not resolve it for you.

    Usually, accounts being titled N/A would indicate a corrupted data file (same with the file being unable to be copied). I know you mentioned that you usually overwrite previous backups, but if you haven't already, I would suggest trying to restore a backup anyway. If the account names do still show N/A, see if it will allow you to change the account name in the restored file.
    -Quicken Anja
  • JBStewartJBStewart Member
    Thanks for your assistance and suggestions. I've decided to open a new Quicken File as a resolution for this issue and retain the previous (apparently corrupted) file for reference. Hopefully this will provide a long-term and lasting solution. I'm also going to modify my backup process to no longer overwrite my most recent backup and retain three to five backups in the event this occurs again.
  • UKRUKR SuperUser ✭✭✭✭✭
    Ok, so the horse may have run out of the barn, so to speak ... but ...
    there's a chance that Quicken has a relatively recent Automatic Backup copy of your data file. Have you looked for one of those yet?

    How to properly set up Quicken Backup
    How to make Quicken create a backup for you automatically every time you close Quicken
    What Quicken backups are available where?

    For the sake of this discussion it is assumed that your Quicken data file is located in the Default (and recommended) place: C:\Users\username\Documents\Quicken

    Review the backup settings available in Quicken (under Edit / Preferences / Backup).

    In there you will find two types of backup: Automatic and Manual Backup.

    Automatic Backup should be enabled and always goes to a \Backup folder that's part of the folder which contains your current Quicken data file, e.g. \Documents\Quicken\Backup. Set it to create a backup after running Quicken [1] times and to keep [9] (or more, your choice) backup copies.
    The file name for Automatic Backup files contains a date and time stamp as part of the file name, e.g. QDATA-2020-03-22.PM03.45.QDF-backup

    To create a Manual Backup copy of your Quicken data file on an external device (USB-hard drive or USB memory stick recommended), put a checkmark at "Manual Backup Reminder" to enable the function and set "Remind me after running Quicken [xx] times" to [1].

    Click OK to save the changes.

    From now on, when you close Quicken using the red X button, you will get a popup window.

    When you get this window for the first time, on some versions click the radio button for "Backup on my computer".
    Change the Backup File name's drive letter and path to point to your external device so that it looks something like this: E:\Quicken Backup\QDATA-2019-04-01.QDF-backup
    or use the Change button and work your way through the dialog.

    Do not change the filename portion! Just overtype the drive letter and choose a backup folder name. If the folder does not exist, it will be created.

    Also choose the option to "Add date to backup file name".

    Every day when you run Backup or close Quicken, an additional backup file is created. Without the Add Date option you only have 1 backup copy which is overwritten every day ... and that may prove bad in a problem recovery situation.

    Allow this backup to run to save the changes made on the screen.

    Of course, once in a while you will have to go in and delete some of the oldest backup files, at your discretion, to avoid filling up your USB device.

    One can never have enough backups of a Quicken data file. BTDTGTS!


Sign In or Register to comment.