Use a SQL Server backend.

No, than does not make my application run faster.

Perhaps you mean 'rebuild your application entirely, using
client-server principles'?

No, that does not make my application run faster.

One of the regular posters here has a relevant comparison:

A sports car is faster than a bus. But a bus can get 30 people
from A to B faster than the sports car.

The bus is SQL Server. It is not faster. Jet is faster.
But SQL Server can do more transactions on a larger
database in the same time.

One of the reasons Jet is faster is that it is a distributed
database engine. Most of the processing takes place on
your workstation. You don't have to share your processor
and memory with all the other people doing transactions.

One of the reasons SQL Server can do more transactions
on a larger database in the same time is that the Jet records
remain locked for longer. Jet does automatic retries when
there is a locking conflict, but it limits the throughput of the
system.

(david)


"ManningFan" wrote in message
ups.com...
Use a SQL Server backend. And index your tables properly.

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