How to run query with huge table


Jump to Page:
< Previous  [ 1 ]    Next >




adnancanada   
Member since: Jan 09
Posts: 107
Location:

Post ID: #PID Posted on: 22-10-15 21:54:47

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.



rajcanada   
Member since: Jul 03
Posts: 2713
Location: Kitchener, ON

Post ID: #PID Posted on: 23-10-15 07:39:41

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 ||




Jump to Page: < Previous  [ 1 ]    Next >

Discussions similar to: How to run query with huge table

Topic Forum Views Replies
Sponsoring spouse in the philippines ( 1 2 3 )
Family Class 3875 15
Before Posting Your Query On this Forum.
Independent Category 1368 0
Regarding admissions in school
Ask Immigration Expert 1450 3
Shipping Goods to Canada
Moving Soon 2021 3
Please clarify
Ask Immigration Expert 1192 1
Seeking Expert Opinion
Ask Immigration Expert 1409 2
Poll: Sponsoring Spouse from India while sponsor person not in canada
Ask Immigration Expert 1742 2
immigration tips for CA from india
Ask Immigration Expert 1536 1
Moving to Atlanta
Relocation 1814 3
Amortization Table
Real Estate & Mortgages 1731 5
Dining Table
Shopping 2421 2
Looking for a furnished Apartments around Square one
Real Estate & Mortgages 1544 1
where to buy home furniture?
Shopping 2586 3
Please answer on my query!!
Ask Immigration Expert 1149 0
LOOKING FOR FOLDING BED---
Life 2413 4
Undergrad in Engineerng
Study 1419 2
Need to move a dining table - what are my options? ( 1 2 )
Life 3353 10
Outsourcing Business
Business 2282 5
Query
Family Class 1307 0
Table Tennis
General 1699 4
Table Tennis
General 1472 3
Looking for Kids table
General 1898 2
Dinig Table
Life 1680 4
How to run query with huge table
Science & Technology 2062 1
Dinner for 15 people in Brampton / Mississauga ( 1 2 )
General 3881 11
 


Share:
















Advertise Contact Us Privacy Policy and Terms of Usage FAQ
Canadian Desi
© 2001 Marg eSolutions


Site designed, developed and maintained by Marg eSolutions Inc.