Examples of retrieving info from Raiser's Edge MS-SQL/Server tables via MS Access.
All of these examples link to the RE tables via an ODBC source. It will be necessary to change the ODBC source via the Linked Table manager. The proper DSN name in most Raiser's Edge installations will probably be something like RE7_1.
| 6/1/2004 |
This example has a form for doing address lookups on a constituent. Look at the design of the "Preferred Address" query to see how the tables relate. Note: The KEY_NAME field of the constituent table includes spouse and alias names. Also, perceived performance is pretty slow when the form first opens. I don't know how to speed that up. |
Address Lookup Example (gzipped MDB) Same file - remove the '-x' from the suffix |
| ... |
Your feedback and questions are welcome. My email is luongo@wi.mit.edu