Access.2007.VBA.Bibl..

strDBNameBackup = Left(strDBName, Len(strDBName) - 4) _ & “ Backup for “ & FormatDateTime(Date(), 1) _ & “.mdb” MsgB ...

FIGURE 17.18 Opening the Administrative Tools program group in the Control Panel. FIGURE 17.19 Selecting the Task Scheduler in t ...

In the Task Scheduler window, select Create Basic Task (Figure 17.20). FIGURE 17.20 Creating a Basic Task in the Task Scheduler. ...

On the next screen (Figure 17.22), make a selection for when the task should be run (choose Daily to run it every day). FIGURE 1 ...

Next, specify an action to run at the specified time. Selecting “Start a program” runs a script (see Figure 17.24). FIGURE 17.24 ...

The final screen of the Task Scheduler Wizard displays a success message, shown in Figure 17.26. FIGURE 17.26 The final success ...

Summary ........................................................................................................................ ...

Y ou can store data directly in an Access database, but Access also has the capability of storing and retrieving data using othe ...

Windows security settings just to be able to connect to SQL Server before you even attempt to con- nect Access to SQL Server or ...

If you don’t have SQL Server 2005 installed, you can download the Express version free, from http://msdn.microsoft.com/vstudio/e ...

Part III Adding More Functionality to Office Making Hidden Tables Visible T o make hidden tables visible, click File➪Access Opti ...

You may have code in an Access database that was originally created many versions ago, but you haven’t upgraded it because it st ...

Part III Adding More Functionality to Office SQL Server Books Online Y ou can download a set of books on SQL Server 2005 from ht ...

Server (or SSE) available as a back end for Access. By default, when SQL Server (or SSE) is installed, it may not be set to run ...

FIGURE 18.2 Selecting the SQL Server Configuration Manager item on the Start menu. FIGURE 18.3 Selecting the SQL Server 2005 Ser ...

As depicted in Figure 18.4, right-click the SQL Server (SQLEXPRESS) row and select Properties. The selection is “SQL Server (S ...

Click OK. Next, right-click the SQL Server Browser row and select Properties. Click the Service tab and set the Start Mode attr ...

Next, you must enable network access — this is required even if you are connecting to SQL Server on the same computer. Start by ...

Next, you have to configure SQL Server to allow remote connections (for some reason, this is nec- essary even if you have instal ...

FIGURE 18.11 Surface area configuration for SQL Server. When you close this dialog, you will be back on the SQL Server 2005 Sur ...