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

Part V: SQL Server/MSDE Administration > External Data Sources

Chapter 24. External Data Sources

Using Access mdb databases, it is easy and uncomplicated to link tables from other database programs or servers, where links to these tables are created using Indexed Sequential Access Method (ISAM) or open database connectivity (ODBC) drivers. In the mdb, select File, then Get External Data, then Link Tables, and then select the required data source. In Microsoft Access adp projects, this simple link to other data sources is no longer available. In the project, it is only possible to use tables from Microsoft SQL Server/MSDE. There are, however, three different options if you still want to use other data sources:

  • Access the data sources directly using the Microsoft Visual Basic for Applications (VBA) program with ActiveX Data Objects (ADO) connection objects.

  • Create linked servers within a SQL Server/MSDE server.

  • Create an ad-hoc link with Transact-SQL commands.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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