Help trying to restore database!

SkolnickSkolnick Member Posts: 31
Nav 4.0.

Trying to restore a database for a test company and getting an error message:

You cannot delete or change the type of the User ID field (in the Salesperson/Purchaser table) before the value in the field is reduced to 0 (zero) or "(blank)" in all records. This message occurred because a nonzero value was found for the record Code='BCC' in company Company 1.

BCC are the initials of a salesperson and Company 1 is the name of one of our companies.

The restore will load companies but no data. Don't know what the problem is and how to correct it.

Thanks for any help....
Making the world a better place one pixel at a time!

Comments

  • SavatageSavatage Member Posts: 7,142
    search the forum for restore database error

    There are many posts perhaps one can help you.

    http://www.mibuso.com/forum/search.php
    select search for all terms

    perhaps using readonly mode can help
  • SkolnickSkolnick Member Posts: 31
    Thanks for the response. I thought I would try something else and it did work.

    Seems if you are using 4.0 SP1, you should not try to load 4.0 and try to toss the database in the wrong version!

    Went out for a ride on my bike, came back and deleted the wrong software, loaded the correct software and everything seems to work fine.
    Making the world a better place one pixel at a time!
Sign In or Register to comment.