Indexing your MS SQL Database to improve performance

Hello again!  It’s been a long time since my last publication, but its better late than never.  My topic today is how to improve database performance to make your application efficient.  To be specific, we would be talking about database indexing. Normally we rely on the Primary Keys as the default index of the table. But in most of… Read More Indexing your MS SQL Database to improve performance

How to solve #Delete records when linking BIGINT MS SQL Primary Key in MS Access?

In MS Access, you will definitely encounter a #Deleted record tags in your MS SQL linked table when the table contains BigInt primary key as shown in the image below: To solve the problem, you need to create a view and cast the BigInt primary key to a VarChar then link the view and not… Read More How to solve #Delete records when linking BIGINT MS SQL Primary Key in MS Access?

How to export Access Reports to Excel less DoCmd.OutputTo object?

When the customer requires you to be absurdly perfect, specially in exporting reports to Excel, the DoCmd.OutputTo object becomes utterly useless, because it throws a lot of garbage columns in your exported Excel file.   It is also useless to export directly the table source of your report to Excel because it will disregard your subtotals. … Read More How to export Access Reports to Excel less DoCmd.OutputTo object?

Innosoft’s Slaughterhouse/Production System

The Slaughterhouse/Production system of MMPC is Innosoft’s first fully integrated industrial information system, a system that includes machine and user entry.   The system covers processes from receiving of livestock to packaging fabricated meat products.  The process involves changing of material from one activity to another, for example, we received a live cattle at the… Read More Innosoft’s Slaughterhouse/Production System

How to update the Main Office MySQL database using DropBox?

Most of my MS Access + MySQL clients have multiple branches.  One of their requirement is to consolidate the transaction/database of their branches to the main office.  My previous solution was to use FTP+MySQLDump, but now we have a better solution, the DropBox. The first step is of course to download the DropBox utility through… Read More How to update the Main Office MySQL database using DropBox?