How to Swap the Bestsys
Description
Cause

The bestsys database can have issues if multiple Sybase engines are running on your network. You need to swap the Bestsys database (Bestsys.db) if your attachments path won't save, or you have problems registering with the correct codes.

You'll need to swap the Bestsys if the program provides any of the following messages:

  • The current database could not be opened because it is designed for use by a newer Sage Software application
  • Available Seats: Static
  • 150 of 200 Deactivations
  • The System detected that the system database needs to be converted before it can be used in the current product version. In order to convert to the latest version, the database must be compatible with the product version 20xx.x or higher
Resolution

Verify the path to the Bestsys.db. Ensure the System account has full control under Sharing\Permissions for the Server installation folder on the server.

Warning: You’ll need to recreate Security configurations and re-register the program after swapping the BESTSYS.DB file. See How to set up Password Security? and How to register the Sage Fixed Assets - Depreciation Network version

Note: This solution is for the Network version of Sage Fixed Assets. If you have the Premier version, see How to swap the Premier Bestsys.

To swap the Bestsys:

  1. Stop the Sybase SQL Engine on the server:
    • Start, Programs, Sage Fixed Assets, Tools, Database Utility - Network Depreciation & Tracking, click Service Manager, click Stop
      OR
    • Control Panel, Administrative Tools, Services, right-click Sage Fixed Assets Service, select Stop
  2. Browse to the BESTSERV, FASServ or SFAServ folder.
  3. Rename the Bestsys.db to "old_Bestsys.db".
  4. Delete or Rename the Bestsys.log.
  5. Right-click the Bestsys.sav, select copy. Right-click the same directory, select paste, which will create a "Copy of Bestsys.sav".
  6. Rename the Copy of Bestsys.sav to Bestsys.db.
  7. In the Service Manager or in Services, start the Sage Fixed Assets Service.

Add existing databases to the list in the Database List Manager:

  1. Click Find, Browse to the database location.
  2. Click OK, and click Search.
  3. Once found, highlight the database, click Add.
    Notes:
    • If the Find screen has a name for the database, the database will disappear from the list of found databases.
    • If the Find screen doesn’t have a name for a database, the database wasn’t on the Database list before swapping the Bestsys.db.
  4. Click Close, then click Close on the Database List Manager.
  5. Go to File, Open Company, select the newly add database, select a company from the list, click OK.



[BCB:165:Chat Fixed Assets US:ECB]




Steps to duplicate
Related Solutions