Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    47

    Unanswered: Performance Slow but CPU and Memory Usage is Low

    My Databases are running very slowly but when I look at the Task Manager the computer is only using 0%-9% of the CPU and about 1/3 of the Memory. This is the computer as a whole. Access is using even less.

    Is this an Access Problem or a Computer Problem?

    I have reviewed the post on this site, the KB, the help, books and I can not get these to run as fast as it seems they should be.

    Any thoughts or suggestions would be greatly appreciated.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Networked application? If so, is it split? Some general thoughts here:

    http://www.granite.ab.ca/access/performancefaq.htm
    Paul

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I had extremely slow MSAccess network performance when our network guy had daisy chained hubs (I also saw that MSAccess was using 0-9% in task manager) . I'm not a network guy but I know when he eliminated the hubs, performance shot way up. He also changed out the slow network cards. Performance increased but I didn't necessarily see MSAccess using more in task manager.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Jan 2006
    Posts
    47

    Subdatasheet Name on Linked CSV

    Quote Originally Posted by pbaldy
    Networked application? If so, is it split? Some general thoughts here:

    http://www.granite.ab.ca/access/performancefaq.htm
    Thank you for this link...

    I was about to apply the Subdatasheet Name to [None] but the linked table is a CSV file. I am not able to alter the table on the back-end. Is there a way to change this for a linked CSV File?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •