1 / 32

Access & ODBC

Access & ODBC. Managing and Using ODBC Connections. P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com. Access Utilities. Linked Tables. P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com. Linked Tables.

kitra-miranda
Download Presentation

Access & ODBC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access & ODBC Managing and Using ODBC Connections P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  2. Access Utilities Linked Tables P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  3. Linked Tables • Powerful feature of Microsoft Access • Very widely used • Sets up “pointers” in the database • Can link to text, Excel, dBase, etc. • Another type of data source is ODBC Access Utilities

  4. Access Utilities ODBC P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  5. ODBC • ODBC = Open Database Connectivity • Microsoft supplies a generic middleman driver with Windows • Vendors supply drivers for their specific database or data source • This enables Access to link to data in almost any kind of database including Oracle, MS SQL Server, DB2, MySQL, etc. Access Utilities

  6. Access Utilities Linking Tables Via ODBC P.O. Box 6142 Laguna Niguel, CA 92607 949-489-1472 http://www.d2associates.com Access Utilities

  7. Linking to ODBC tables • 3 scenarios • The ODBC connection (DSN or Data Source Name) exists already (perhaps provided by IT group) • Create the DSN in advance via Windows • Create the DSN connection while going through the link table procedure Access Utilities

  8. Launch Link Tables Dialogue(Existing DSN scenario, Scenario 1) Access Utilities

  9. Link Dialogue Select files of type ODBC Access Utilities

  10. Select Existing Data Source Access Utilities

  11. Login to Data Source Access Utilities

  12. Select Tables to Link Access Utilities

  13. Access Database Window with Linked Tables Access Utilities

  14. Create New Windows DSN(Scenario 2) • As stated before DSN typically created well in advance by IT • But…for illustration purposes we will create it ourselves • This scenario thus has two major steps • 1 – create the DSN under Windows • 2 – Launch the link tables dialogue in Access and proceed. We have already done this, so this will not be repeated here Access Utilities

  15. Key DSN Properties • Name • Driver • Database Name • Authentication Method • User Name/Password (if using SQL Server authentication) Access Utilities

  16. Launch Control Panel(Create DSN in Window second scenario) Access Utilities

  17. Control Panel Access Utilities

  18. Administrative Tools Access Utilities

  19. Add DSN Access Utilities

  20. Select Driver Access Utilities

  21. Create New DSN Access Utilities

  22. Specify Authentication Method Access Utilities

  23. Specify Database in SQL Server Access Utilities

  24. Accept Defaults Access Utilities

  25. Review Properties and Test DSN Access Utilities

  26. Rocky2 DSN Tests OK Access Utilities

  27. Rocky2 DSN now available Note: the rocky2 DSN is available for all applications that can use ODBC, not just Access Access Utilities

  28. Link Tables(Use created DSN; still in second scenario) • We will now go through an abbreviated series of slides showing how the new DSN can used. Access Utilities

  29. Launch Link Tables Dialogue(Use created DSN; still in second scenario) Access Utilities

  30. Select New Rocky2 Data Source Access Utilities

  31. Select Tables Access Utilities

  32. New Bookstore Database with Linked Tables via rocky2 DSN Access Utilities

More Related