Solution Properties
Solution ID:
222924150017059
Last Modified Date:
Fri Mar 31 15:42:13 UTC 2023
Taxonomy Path:
Category//Setup and configuration
Author:
sageadmin
How to add an existing database to the Database list manager Single user
Description
Cause

There are several reason why an existing database will need to be added:

  • The database was removed from the Database List Manage
  • The system database became corrupted and needed to be swapped with the blank saved copy
  • The database file was copied from another system (an unsupported migration)
Resolution
The preferred method of moving data is by the Restore Company function. See How to migrate Sage Fixed Assets Single User products. If you cannot access an existing installation of Sage Fixed Assets and have copies of the database files, follow the process below:

  1. Create a new folder in the default data folder.
  2. Copy the best.db, fas.db, or *.bdb files to the new folder on the the system the single user product is installed. Do not move any .log or .id files.
  3. Go to File, Database List Manager.
  4. Click Find, Browse to where the database(s) is located, click OK, click Search.
  5. Once found, highlight the database, click Add.
    • If the database is already named in the Find screen and it is already Database List Manager, it will not need to be added again
    • If the database is currently not-named, there will be a prompt to give it a name, both the Database Name: and the Database File Name: will be available Do not change the Database File Name: but give it the Database Name: only
  6. The database will disappear from the list of found databases.
  7. Click Close, and Close.
  8. Go to File, Open Company, select the newly added database, select a company from the list, click OK.


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

Steps to duplicate
Related Solutions

How to migrate Sage Fixed Assets Single User products