Home Forums SQL Server 2008 SQL Server Newbies A better way to query data currently being done with a linked query in Access RE: A better way to query data currently being done with a linked query in Access

  • I would probably bring all the data down into Access and index the tables -- after you have all the data. Then build your query there. When you're done, truncate the tables in your Access DB. (don't want that stuff laying around for someone to misuse.)