How to clean the pcAmerica database

Our goal here is to make your pcAmerica CRE or RPE run faster. After time you may notice your system running slow and sluggish. Do a manual backup of your database and check the file size. If it’s getting rather large (Over 1-2GB) you might want to try this.

Warning! NEVER erase your transactions without doing a backup of the database. You will lose all reporting. On the versions that I have done this on I have not lost any internal gift card balances. However I do recommend using an external card service like StoreCard.

Once you change the Database name on the master computer you will need to do any Slave machines as well.

I recommend doing it this way because of the ease of switching back to the original database in case you need to run a report. No fumbling around looking for your backups. This is a good way of doing it say on January 1st and starting the year fresh.

Please remember to change the database name in the config file inside your auto backup folder. Hopefully you have taken 5 mins to set that up?

My Delete Button is Gone!

Pcamerica delete key is missing.

The #1 most common support call I get is “What happened to my Delete Button?’ It was just there and now it’s gone… I can’t delete anything.

Solution is to press F12 on your keyboard or look to the lower right of your screen where it says “F12 Item Options”
Since you have pcamerica cash register express and using a touch screen monitor you accidentally pressed that button resting your hand in the corner.


Read more

Error 1603 Fatal Error during installation

So trying to update to a newer version of PCAmerica I get this random error. It has taken me a little time to write this but I believe I was trying to update somewhere around the 12.6xx to a 12.7xx .

If I run into this error again I hope to give you an exact version that gave me the problem but the fix was to update the .NET Framework. I think I updated to 4.6.2 and that fixed the problem.

So if you get this error don’t sweat it. Easy fix.



Cash Drawer Won’t Open

This is very common and usually an easy fix. The cash drawer is normally controlled by the receipt printer.

  1. Check to make sure the power is on to the receipt printer.
  2. There is a cable that runs from the Receipt printer to the Cash Drawer, make sure it’s plugged in.
  3. Shut the Receipt printer off, wait a minute and then turn back on. Try unplugging and re-plugging the USB cable if available.
  4. Restart the entire computer.
  5. If you have a USB printer go to Device Manager, expand the USB Controller and change settings to all USB Root Hubs. Power Management tab. Uncheck “Allow computer to turn off device to save power” Hit OK.


If still unable to open the cash drawer many have a manual release switch located underneath usually toward the back half of the cash drawer. Or if you have the KEY use that to release the drawer.


On a personal note, I have experienced less headaches by using serial receipt printers as opposed to USB printers. But with the lack of serial ports on most new computers USB printers are more common.

Bixolon SRP-350IIICOSG. Serial/USB Thermal Receipt Printer

AutoMatic Backups

It is highly recommended to set your “Master” “Server” or “Computer” whatever runs your Database to “AutoMatic Backups. Especially if you are running in house Gift and or Loyalty cards. You DON’T want to lose that info!

Doing AutoMatic backups will save copies to your hard drive but to be fully protected you need to set your backups to send a copy to an online “Cloud Based” Storage folder for added protection and piece of mind.


Windows XP seemed to be a bit more difficult to set up with both the AutoMatic Backups and the AutoMatic backups to the Cloud. So if you are still running XP I would highly recommend installing your Backup on to a newer version of Windows on a NEW Hard Drive.