Access.2007.VBA.Bibl..

FIGURE 18.39

An Access form displaying data from a linked SQL Server table.

Creating a Client/Server Application ........................................................................

Compared with just converting the tables to SQL Server tables, and linking the Access database to

them as a front end, creating an Access Project as a front end has several advantages: You can make

design changes to SQL Server tables and views, some of which can’t be edited from an Access front

end. You can also create, edit, and use other SQL Server objects, such as database diagrams, stored

procedures, and user-defined functions. In a linked Access front end, by contrast, you can’t make

design changes to any SQL Server objects, and you can only link to SQL Server tables and views.

To create a client/server application from an Access database, with an Access Project (.adp) as the

front end to the SQL Server back end, proceed as in the previous section until you reach the screen

offering a choice between creating a client/server application or linking to the SQL Server back end

(this screen is shown in Figure 18.40); in this case, select the client/server application option, and

edit the name of the new project as desired.

Working with SQL Server Data 18