Microsoft Office Tutorials and References
In Depth Information
Using ODBC
Book IX
Chapter 2
Downloading SQL Server Express Edition
If you have access to a full-blown version of
Microsoft SQL Server, or if one is running in
your company (or basement) already, consider
yourself lucky. But if you’re trying to get
familiar with SQL Server and haven’t hit the lottery
lately, you can download a scaled-down
version for free. This version slices and dices just
like the full version of SQL Server, but it has a
database-size limitation. As of this printing, you
can download it at www.microsoft.com/
express/database .
Alternatively, because Microsoft likes to
change its URLs more often than gas stations
change their prices, you can just do an Internet
search for SQL Server Express download.
Figure 2-1:
Linking to
an ODBC
database
from the
Access
Ribbon.
When the Get External Data – ODBC Database dialog box opens, Access gives
you two choices: import or link to the data. Because you’re using Access as
a front end to manipulate data in SQL Server, select the option to link to the
data source (as shown in Figure 2-2), and click OK. If you import the data,
you’ll get a snapshot of the data at the time you performed the import, and
any changes you make won’t be reflected in SQL Server.
For further assistance on when to import data and when to link to data in
another data source, see Book II, Chapter 4.
Next, the Select Data Source dialog box opens, as shown in Figure 2-3. This
dialog box lets you choose an existing ODBC data source or create a new
one. After you create a connection to a particular database, it appears in
the list. If you’re connecting to a data source for the first time, you have to
create a new data source.
Search JabSto ::




Custom Search