Help CenterThis guide is intended to help access the database directory for PCProg in Windows 10 or Windows 11 for purposes of backing up PCProg's database files.
Before you Begin...
Please note that this guide is intended for advanced users only. If you need assistance, please contact Optima Support at 1-888-475-2767 or at possupport@optimagopos.ca .
Instructions
Log onto your PC or laptop running PCProg. Once logged into Windows, open File Explorer.
Once the window is open, near the top, select View, and make sure File name extensions and Hidden items are checked.
Next, in the navigation pane on the left-hand side, highlight the icon This PC. You may notice an arrow to the left of it, and if it shows pointing right, click on the arrow to expand the list, and the arrow will point down. If the arrow is already pointing down, then scroll down and select your C: drive.
From there, we will attempt to search for the following files in question by using the search bar at the top right of the window, and then enter one of the following:
PCProgDB.db (Main Program Database)
PCProgTransData.db (Transaction Data, Reports, and Inventory Database)
Press enter and give Windows a few moments to search the file. If the file appears and is highlighted, you can note the directory shown below the filename. If you hover your mouse cursor over the file name, you will see the full directory of where the file is located on the hard drive. Next right-click on the file, then select Open File Location.
If the file does not show after a few minutes of searching, you will then need to manually navigate to the file itself. Generally, the file directory tree should be similar to the one below.
C:\Users\<USER>\AppData\Local\OptimaSystems
NOTE: The name <USER> is the username you use as your login for Windows. The file should be in the OptimaSystems folder. The image below (from Windows 10) should be a prime example of what we have discussed up to this point.
If you do not see the OptimaSystems folder, or got lost while you’re in C:\Users\<USER>\AppData\Local folder and don’t see the OptimaSystems folder, it will be in another subdirectory folder called Packages, followed by another folder in a long alphanumeric name. In that folder, there will be the LocalCache folder, and then inside that folder, will be the Local folder, and then the OptimaSystems folder. The following is the full directory of where the database files will be:
C:\Users\<USER>\AppData\Local\Packages\8f8842a3-2e40-4b33-9349-10524cd8acb0_d4v55k16rs4gg\LocalCache\Local\OptimaSystems
NOTE: For PCProg 1.0.19.1 and beyond, the folders have been named a bit different. Here is the following path:
C:\Users\<USER>\AppData\Local\Packages\ 8f8842a3-2e40-4b33-9349-10524cd8acb0_e2d40dpq514c6\LocalCache\Local\OptimaSystems
Once you’re in the OptimaSystems folder, you should then see both the PCProgDB.db and PCProgTransData.db files.