Greetings Experts! This question stems from the link below. I have collaborated with an Expert to develop an Excel Help desk that is being used alongside an Access Database. In addition, this Access Database is linked to an Oracle database.
The intent here is to add a search tool that will enable the user to search for an item in a database and pull information relating to the item searched. The database contains roughly 620,000 items, so all of my attempts have resulted in VERY long search times or endless loops/crashes in Excel.
I have attached the Excel Help desk spreadsheet and the Access Database involved. Thank you so much for the help with this.