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

Chapter 20. Client/Server Techniques > Connecting to a Database Server

Connecting to a Database Server

After you define a data source, you are ready to connect to it. You can use these methods to access server data:

  • Link to tables residing on the server.

  • Link to views residing on the server.

  • Use pass-through queries to send SQL statements directly to the server.

  • Use VBA code to open the server tables directly.

  • Use ODBCDirect to open and manipulate the server tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint