Hi I am using MS Access 2013. I have link table coming from SQL Sever has huge data records more than 50 million. Whenever I run any query it freeze my computer or it takes lot of time. I tried pass through run well if there is no filter on it when you put some criteria it behave same as normal query does. Is it possible to create index via pass through query ?
Is there any best way to handle large data table so I can run my query.
Thanks.
Is there any best way to handle large data table so I can run my query.
Thanks.