View Single Post
  #26  
Old January 10th, 2007, 09:33 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
Anthony
external usenet poster
 
Posts: 176
Default Free for All: help me speed up my Access Database

damn!

"'69 Camaro" AM wrote in
message ...
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.


Don't forget to compact it afterwards to squeeze all the excess air out so
you get the best aerodynamics for that hyperspeed.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"John Nurick" wrote in message
...
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.