Using Microsoft Access
Using Microsoft Access
MRDB views of tables and reports can be accessed directly through Access or Excel by setting up an ODBC driver on the desktop and linking to the views.
Steps:
1. Click Start at the bottom left of the screen, select settings, control panel, then ODBC 32 icon.
2. Click the Add button, then Select the Oracle ODBC 8.0 driver and click Finish
3. Type in mrepp1 in the Data Source Name and the Service Name and click OK.
4. Create a blank database in Access and chose File, get external data, link to table. Choose the ODBC file type to link.
5. You are asked to chose your data source. Click the Machine Data Source Tab and select the driver you set up earlier.
6. Sign on by entering your RACF ID and the word PASSWORD. Click on the views to link. When you click OK certain tables will ask you select a unique record identifier, just click OK without choosing any fields.
7. Now treat the view as if it were an Access table. Save the database, and next time you bring it up the links will still be there, but you have to log in to Oracle the first time you try to open it. If something changes to the underlying view you will have to delete the link and reestablish it.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- using access to open a database file schools and
- macintosh microsoft office 2004 and microsoft access
- microsoft access table design academic web pages
- using microsoft access
- microsoft access database for usda ars form 182b
- microsoft access
- microsoft access 2000 getting started
- microsoft access xp part ii tables queries
- introduction to access maine
- microsoft access 97 lab session 1 siue
Related searches
- microsoft access 2013 user guide
- using microsoft to do with onenote
- microsoft access help guide
- microsoft access one to many
- free microsoft access for students
- microsoft access syntax list
- microsoft access listbox
- microsoft access 2019 for students
- microsoft access inventory templates free
- microsoft access inventory database templates
- free microsoft access database templates
- microsoft access inventory database samples