Backup of SQL Server databases from within Microsoft Access

Sent to you by DuyTuan via Google Reader:

Backup of SQL Server databases from within Microsoft Access

via Tony's Microsoft Access Blog by Tony on 12/16/12

WARNING:  Some of the following instructions may not be best practice.    This is a personal database so I can afford to take some shortcuts and not do thorough research.  If you do use these tips and sample code in production check back in a week and a month to see if there are any changes or comments.

Objective

I wanted to create a method of backing up a personal SQL Server database from within Access.   In a production environment you'd have tasks which ran on a regular basis, i.e. at midnight or whatever, that would do this.  But here I might update some records every few days and wanted to do this on my schedule.
Note that, as the names of the stored procedures indicate, I will be modifying these as I add more functionality such as database checks, log truncation, etc.

General SQL Server setup tips

[Clip]Export Access to MySQL

Export two Access tables into individual sheets in an Excel spreadsheet in Access

Question: In Access 2003/XP/2000/97, I want to set up a form with a button that a user can click. When the button is clicked, I want to export two Access tables into an Excel spreadsheet. I want each table to appear on its own sheet in the Excel file.
Answer: We've created a sample Access database that you can download that demonstrates how to export two Access tables into the same Excel file.