Thread: Free for All: help me speed up my Access Database
View Single Post
  #19  
Old January 10th, 2007, 08:25 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
John Nurick
external usenet poster
  
Posts: 492
Default Free for All: help me speed up my Access Database
On Wed, 10 Jan 2007 12:37:10 -0600, "Anthony"
wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?

Single user, not split, on a RAM drive on a superfast machine.

And it's even faster if you delete all the data: that way, you don't
even need to open the database to know the answer it will give you.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.