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


  2. #2
    PeterK Guest

    Re: Access running slow...

    Take a look at the tips on this site.

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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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