The new SQL Server database is created in the SQL Server data folder, typically C:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. The database has the .mdf extension, and there
is also a matching transaction log file with the .ldf extension. The Access front end now has two
sets of tables: the original (pre-upsizing) Access tables, renamed with the suffix _local, and the
linked SQL server tables, as shown in Figure 18.38. The SQL Server tables are indicated by the
arrow and globe icon.FIGURE 18.38
Linked SQL Server tables in the upsized Access database.In the Access front-end database, forms and reports should work as with local Access tables. The
Orders form is shown in Figure 18.39, displaying data from the linked SQL Server tblOrders.Two of my original reports, however, wouldn’t open, with Error 3219: Invalid operation. This
turned out to be because the reports (or their data source queries) used the FromDate()and
ToDate()functions. I made copies of the queries and reports without these functions; you can
compare rptInvoices and rptInvoicesDateRange, and rptEmployeeSalesByCountry and
rptEmployeeSalesByCountryDateRange, in the Basic Northwind.accdb database.Part III Adding More Functionality to Office