DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Access running slow...

Hybrid View

  1. #1
    Wayne Guest

    Access running slow...


    I have around 31 tables in a SQL Database. The SQL database is on a server
    in another building. My Access database will be in the same building but
    on a PC. In Access, I have the tables linked to the SQL Database. Some of
    the tables have around 200,000+ records.

    When I try to open a form in Access (I am running a query to filter for certain
    data chosen by the user)it sometimes takes 8 to 10 seconds to bring up the
    data. What can I do to speed up connection or bring data to Access faster.
    I hope this makes sense.

    Any help???

    Thanks

  2. #2
    PeterK Guest

    Re: Access running slow...


    Take a look at the tips on this site.

    http://www.sql-server-performance.com/



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center