Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Linking Access Front Ends to... > Separating Tables from Access Front-...

Separating Tables from Access Front-End Objects

Making your Access application accessible to more than one user at a time requires dividing the application into front-end and back-end components. For Access databases, the front end contains all application elements plus queries; the back end contains only Access tables. If you use the Upsizing Wizard and choose to link your Access application to the Microsoft SQL Server 2008 R2 or earlier Standard or Express Edition (SSX), SQL Server tables replace Access tables. The linking process for Access tables is similar to that for linking dBASE files; linking SSX tables uses the Open Database Connectivity (ODBC) driver.

To review the table linking process for dBASE files, see Linking and Importing External ISAM Tables,” p. 324.



  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint