How do I rename or move a database in BillQuick?
The instructions below apply to renaming both a standard database (Microsoft Access) as well as an SQL database. Follow the steps for your respective database type.
Standard Database (Microsoft Access)
1. Determine the name and location of the database by looking at the status bar at the bottom of BillQuick, say Sample_Datafile20xx.mdb.
2. Before renaming, you must have all users that are currently logged into BillQuick log out of BillQuick.
3. Go to the BillQuick installation folder and select the desired database.
4. Right-click on it. Select Rename and give that database a new name.
5. Upon launching BillQuick, because it is expecting the old name, you will get the following message indicating that BillQuick is unable to connect to your database.
6. Click OK. The Welcome to BillQuick screen displays and you can open your existing renamed database from here.
7. There are three additional files to note: Archive, Backup and Password.
- Archive - If used, this is a separate database and the name must match that of the BillQuick database. There will be a database with the same name and an extension of ar*. You must change the name of this file as well to match your BillQuick database.
- Backup - Any file that has an extension .Pr is essentially a backup made after running the Repair and Compact Database utility within BillQuick.
- Password - The file with a .PWD extension is an encrypted password file used to lock the database. It will be created once the database is opened with the new name. The old file will then be safe to delete.
SQL Server Database
Note: Steps 1 and 2 are the same as above; however, renaming an SQL database is done via SQL Server Management Studio (SSMS).
1. Determine the name and location of the database by looking at the status bar at the bottom of BillQuick.
2. Before renaming, you must have all currently logged in users log out of BillQuick.
3. Open SSMS and go to Object Explorer. Browse to the desired database and right-click on it.
4. Select Rename and give the database a new name.
5. Upon launching BillQuick, because it is expecting the old name, you will get the following message indicating that BillQuick is unable to connect to your database.
6. Click OK. The Welcome to BillQuick page displays and you can open your existing renamed database from here.
7. In addition to the BillQuick database, there should also be a database with the same name and the extension (.)ARK. If you use SSMS to change the name of the BillQuick database, then you must also change the name of the corresponding ARK database in order for BillQuick to use the archive function.