Hi ,
I have table which has almost 1 billion records. Whenever I make any query on Access and run it. It takes forever. It freez my computer. Is there any way to run query. I have link table coming from SQL Server.

Kindly help.

It may be too much for Access to handle.

If you have rights on SQL Server, it may be possible to create a View on SQL server with your SQL query and link your Access to the View instead of tables. This way you limit the records you are bringing into your Access.

Another option would be to create a form in Access, put a button on it and for on click event write VBA code that only copies the result set from SQL server to your Access tables that you are interested in. If you are working for a medium to big organization, most probably your colleagues would have something like this. You can get their sample code and tweak it to match your SQL database and query. Try to ask them. Otherwise you can search Access forums, StackOverflow, etc. MrExcel.com also has a forum for Access developers.

-----------------------------------------------------------------
Give free food http://www.thehungersite.com ||