Make a local ACCESS 2003 db run faster
Posted on 2009-07-08
I have a client that users ACCESS 2003 on local machines. Problem is that they are processing MILLIONS of records. They have so many that they have created a series of databases that hold only one table - which can be up to 5 million records. So, the "processing" database has links to all these "child" databases but queries can take an incredibly long time. The machine has almost 20 Gig of free space and 2.5 gig of ram. They DO NOT want to put anything on a SQL server (my FIRST suggestion). Tables are indexed, but would more ram help? I am at my wits' end as these people will not change but also insist it should run faster. Speed is 2992 MHz. XProfessional, SVP 3. I have contacted their IT department and first thing out of their mouths was put in on a SQL server. I just want confirmation that there is nothing that can be done to get the application to "run faster".