Aldelo is a restaurant Point of Sale and management solution that has helped tens of thousands of restaurant operators achieve simplicity in management and streamline operations. A common complaint, however, is that the system tends to run very slowly over time. Today we will show you how to “tune-up” your Aldelo system so that it runs at optimum speed.

This is the request that we see most often:

“We have 30K orders in our system, please delete them. They are slowing the system down”.

Yes, a large number of transactions in an access database can, in fact, slow down the system. These transactions could have been accumulated over 6 months, a year, or even several years. Aldelo offers a way to complete a so-called “YEAREND” process. This procedure will delete all transactional data while retaining all master records. So if you were wondering, it will keep all delivery addresses, customer files, etc. If compacting the database doesn’t work for you, follow these instructions to delete the transactions. This process does not have to be done at the actual end of the year in December on 31st, you can run it multiple times as you wish.

Before we start, please be sure of the following:

• Create a backup
• Perform this procedure after hours. This will get rid of any open orders in the system.
• Make sure the servers have closed any open orders
• Be sure that your credit card batch has been submitted

Please be careful. The last thing you want is missing orders or a credit card batch. As long as you have a backup, you can always go back and find those transactions you may need.

Note that the process must occur from the POS station where the database is located.

If your database is on the server somewhere, you will need to move it to the POS station. If it is pointed to by UNC path, such as \\Servername\Sharedfolder\database.mdb, then you will need to point to it locally, like this: C:\Databases\database.mdb With these preparation steps completed, you are ready to do the actual work:

• Get to BackOffice and right click the “compact database” button while holding down the left CTRL key on your keyboard. If your version of Aldelo looks different, don’t worry – steps are identical.

• Next, you will see this screen prompting you to enter a password

As of writing this post, I am unsure if we are actually allowed to post this password publicly, so please contact me privately and I will share it with you. Anyway, you type in this password, and

• next prompt shows up