Resource Dynamics, Inc.

Tele-Support HelpDesk Hot Tips

Question:

How do you archive History inquiries from TeleSupport HelpDesk?

Answer:

You must have MS Access and have a working knowledge of the MS Access interface.

1. Make a copy of Helpdesk.mdb.  You will be able to refer back to the data if needed simply by renaming the MDB files.

2. Open the original Helpdesk.mdb with MS Access.  You won't be working any longer with the copy.  It is only needed to resort to for archived data.

3. Click Queries in the Objects column.

4. Double-click on "Create query by using wizard".

5. Select "Table: Inquiry" from the Tables/Queries list box.

6. Click the ">>" button.  This will select all fields.  You don't really need all of the fields, but this will make the instructions easier.

7. Click Next.

8. The "Detail" radio button on the "Simple Query Wizard" screen should be selected.  Click Next.

9. Give the query a meaningful title.  Something like "Delete Old Inquiries" would be good.  Click the "Modify the query design" radio 

button and then click on Finish.  You will see the Query in Design View.

10. In the Criteria row of the SDATE column enter <1/1/02 and press Enter.  Access will correct the syntax for you to <#1/1/2002#.  

This selects all of the records that were started prior to January 1st, 2002.

11. In the Criteria row of the FINISHED column enter =-1 and press Enter.  This selects only the inquiries that are finished.

12. Click on the Run button.  You will see the results of your query in Datasheet View.  These are the records that will be deleted.  Verify 

that these are the records that you want to delete and click on the View button.  Change the view to Design View.

13. Click the Query Type drop down arrow and select Delete Query.

14. Click the Run button.  You will receive a warning that you are about to delete rows from the database.  Click the Yes button to 

delete the selected rows.  Any related records in other tables will be deleted as well.

15. Save the changes to the Query and exit.

Applicable HelpDesk version(s):

2.0

HelpDesk version 2.1 & 2.2 can use the new feature included in the DBUTIL.exe.