Free for All: help me speed up my Access Database

[Darryl Kerkeslager]

For example, I asked a 92 year old grandmother if it was really stupid
that bank machine would first download EVERYONE'S account number, and then
YOU ENTER you account number (PIN) to use the teller machine.
that 92 year old grandmother INSTANTLY could recognize that it is MUCH
BETTER to first ask the user their PIN number, and then ONLY download that
persons information into the teller machine.

What a great example!

 

[BruceM]

I'll have to remember that example about the teller machine. Analogies can
be very helpful.

 

[Keith Wilby]

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

Give it Paula Radcliffe's legs.

Keith.

 

[Marshall Barton]

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

After all the other comments, about all I can add is that
you might gain some improvement from occasionally compacting
the msb files.

Regardless of how effective any quick fix happens to be,
good design is absolutely crucial.

 

[Larry Linson]

from occasionally compacting the msb files.

Marsh, you slipped up typing this... msb files are supposed to be
_secret_... Microsoft Secret Base files! Now you've let the cat out of the
bag.

Larry

 

[Marshall Barton]

Marsh, you slipped up typing this... msb files are supposed to be
_secret_... Microsoft Secret Base files! Now you've let the cat out of the
bag.

There's only a minor twitch betwixt them,
most folks won't even notice the difference ;-)

 

[Anthony]

again, to everyone, dang! ( i decided not to cuss, so I wont say damn.)
oh, damn.

I mean dang.

 

[aaron.kempf]

I call bullshit on this MDB route; MDB is for babies

I can buy a quad core Xeon today for what.. a grand?

SQL Server has obvious performance benefits

-aaron