1. Using the mouse, move your cursor to the section of the screen which displays the tables you want to query (the upper portion of the screen).
2. Click the Right mouse button
3. In the window titled Query Properties, you should see a menu with one of the selections being Properties.
4. Select Properties.
5. You should see another screen which shows the ODBC time-out value of 60 along with some other information.
6. Change the ODBC time-out value to 0 (zero).
7. Close the window by clicking on the X in the upper right hand corner of the window.

An alternative method of accessing the Query Properties window is as follows:

1. From the View option on the tool bar, select Properties.
2. In the window titled Query Properties, you should see a menu with one of the selections being Properties.
3. You should see another screen which shows the ODBC time-out value of 60 along with some other information.
4. Change the ODBC time-out value to 0 (zero).
5. Close the window by clicking on the X in the upper right hand corner of the window.

Before you begin linking and importing tables make sure you know which tables and queries you need in support of the report that you want to import and customize. The example below assumes that you have already downloaded the rpt1800.mdb database from the Microsoft Access Reports Using the IBIS Financial Database web page.   Note:  You cannot import reports from Access 97 into Access V7 for Windows 95, but you can import the tables and queries. You can import reports, queries and tables from Access V7 for Windows 95 into Access 97. You can import reports, queries and tables from the same versions of Access.  

Step 1

• Open Microsoft â Access.
• Create a new database using a blank database.
• Save the database to a location of your choice.
• Click on create.

Step 2:

• Now get the tables with which you want to use.
• Right click in the white area of the table window.
• Click on the link tables… option.
• Next, find the files of type: list box.
• Click on the down arrow.
• The options area should drop down and show different types from that you can select.
• Find the ODBC Databases() option.
• Click on the ODBC Databases() option.

Step 3:

• Now you should see the Select Data Source window.
• Click on the Machine Data Source tab.
• Then look for Warehouse under machine source name.
• Click on Warehouse.
• Click OK.
• You will now be prompted with the SQL Server Login.
• Enter your Login ID and Password.

Step 4:

• You should now see the Link Tables window.
• Click on the Select All button .
• Click OK.

Step 5:

• Access will now ask you to Select a Unique Record Identifier for each of the tables.
• Click cancel each time Access asks you to select a Unique Record Identifier.
• Note: It should ask you to select a Unique Record Identifier 6 times, once for each of the 6 tables to which you are linking.

Step 6

• Notice that you are now back in your original Access database window and it should display all of the tables to which you just linked.
• Each table should have a globe next to it, showing that it is linked to the warehouse and not to a local table on a client.

Step 7:

• Click on the tables tab.
• Right click in the white (not on any of the tables) part of the screen.

Step 8:

• This step is where you find the Access database file from which you want to import the tables, queries, and reports.
• Remember: this documentation uses the rpt1800 database as an example for importing tables, queries, and reports.
  Click on the Import… option in the menu box.
• Now find the rpt1800 database in the accesrpt folder on your C: drive.
  Click on the rpt1800 database.
  Click Import.
• Note: When importing tables, do not import any tables from the data warehouse (tables that have a picture of a globe are linked to the data warehouse). In the rpt1800 database the last three tables are not on the warehouse. Those three tables are the tables that you want to import.

Step 9:

• You should now see an Import Objects window with the tables tab highlighted.
• Click on the tables you wish to import.
• You can also select any queries and reports that you want to import while in the same window.
• Simply click the query tab.
• Click on the queries you want to import or click on the select all button (you do not have to hold down the ctrl button to select multiple queries, reports or tables).
• Click on the reports tab.
• Click on the reports that you want to import.
• To double check that you have selected all of the tables, queries and reports that you want, simply click on the corresponding tab and check to see if the items you want are highlighted.
• After you have all of the tables, queries, and reports that you want highlighted, click OK.

Step 10:

• You should notice that Access shows you the status as it is importing the tables, queries and reports.
• When it is finished importing, you should be back in your original database window.
• Check to make sure that the tables, queries and reports that you imported are there by clicking the tables, queries and reports tabs. 

1. Start Access.
2. Under File, select Link to the tables.
3. Under File of Type, specify ODBC database.
4. Select the data source.
5. Select the warehouse.
6. Enter your userID and password but Do Not Press Enter.
7. Choose Options.
8. At the database drop down menu, select your database.

The additional data table(s) will be displayed for your selection.

To view on the Warehouse:

1. Is your criteria entered with the correct syntax? Spaces where spaces should be and so on. If the field's values are part of a code set, you should check the code set to make sure you are entering everything correctly.
2. If you are still having problem, remove all your criteria but one. Run the query again. If you get some records, add your second criteria. This can help determine where a problem might be.
3. If you are still having problems, contact the user office responsible for the database you are using.
   

• Launch ISQL.
• Connect to the warehouse server.
• Choose a database.
• Type in the following: Select * from a table name. Example:
  -- Choose the IBIS database.
  -- Select * from DLT048.
• Choose Execute Query.

The SQL connection is correct, if data is returned or you receive a message stating there is no data in this table.   If you do not receive any data or a message stating no data is available, check the following:

• ODBC setup
• the application being used (Excel, Access, etc.)

1. Under Data menu, choose get external data.
2. Select the data source.
3. Select the warehouse.
4. Enter your userID and password but Do Not Press Enter.
5. Choose Options.
6. At the database drop down menu, select your database.

The additional data table(s) will be displayed for your selection.