How to Deal with “Can’t Append All Records in the Append Query” Error in MS Access

In this article we examine scenarios which generate errors relating to failure to append records in MS Access In MS Access, an append query is used when a user updates some records to an existing table, usually from other sources.  Append query basically selects new records from other sources of data and copies them to the table in database. It is helpful in appending multiple records at once and it also allows the user to refine the selection with certain criteria. Users can review the...

Read more »

How to Use LOG backup to Find Deleted Objects in SQL Server

In this article, we will learn how to use SQL Server Transaction Log backup files and identify  1) Name of objects that were deleted from the database  2) The User who deleted the database objects SQL Server does not support object-level restore. So, to restore the deleted object, you must restore the entire database with different name and then import the deleted object into the original database. Step by Step Step 1: Create a database and add some tables. As it is just a demo,...

Read more »

How to Auto Capitalize Each Word in Subject when Composing Your Outlook Email

When composing a new email and filling the subject, you may hope that Outlook is able to auto capitalize each word in subject line. Though Outlook doesn’t have a native feature, you still can get it by the means shared in this article. Perhaps you are accustomed to always capitalizing each word in mail subject line when composing an email. Yet, you may think that the frequent case shifts are too troublesome. Under this circumstance, it’s much more convenient if Outlook can auto...

Read more »