Link table more than 50 million records

[adnancanada]

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.

[ranman256]

you are at the mercy of
the type of query
50 M records
memory in your PC
the processor in your pc
the connection.

you may want to let it run.

[pbaldy]

I would probably stick with pass through queries, and use criteria to minimize the records pulled from the server. You want the SQL Server doing the work and sending the fewest records possible back to your PC.

[adnancanada]

I would probably stick with pass through queries, and use criteria to minimize the records pulled from the server. You want the SQL Server doing the work and sending the fewest records possible back to your PC.

Thanks for your suggestion.
I have build pass through query it is running fine. It returns records but I cant judge how many records, when I click on record selector , it freeze my computer. How can bring those record in my Access table. Please help.
Can I make table query using pass through query. Will table create on SQL server ?

[pbaldy]

From the sound of it, so many records are returned that your computer freezes...or at least appears to. It could be as ranman suggested that if you just let it run, they'll eventually show up. I'd test with SQL that you know will only return a few records.

A make table query will make the table in Access, unless perhaps you're dealing with an ADP.