Changes are refreshed on command. This method actually makes sense
with respect to the difference in the functionality and purposes of Access 2007, as compared with
SQL Server 2005.
You could, of course, refresh the other way around and execute a command like this in the SQL
Server database. Figure 40-17 shows a script executed in the query window of the SQL Server
management studio tool, adding a new record, and then displaying it on the screen.
1241
SQL Server as an Access Companion 40
FIGURE 40-16
Access e-mails changes to SQL Server
FIGURE 40-17
Making changes directly into SQL Server tables
1242
Access as an Enterprise Platform Part V
This is the script used in Figure 40-17:
use test
go
insert into region(region_id,region,population,area)
values(14,??™The Planet Jupiter??™,0,1000);
go
select * from region;
go
After running this short script and reopening the Access 2007 database, the linked table
(dbo_Region) contains the record just added in SQL Server (see Figure 40-18).
Pages:
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280