Speed Enhancer

[Annabelle]

Does anyone know of a speed enhancer for Access. I have split the database. It has been compiled. And I often Compact and Repair the Database.

Is there a way to speed enhance the database.

 

[llkhoutx]

That's a really nebulus question. Litwin, Getz, et al 's Access Developer's Hanbook has a litany of speed enhancers.

For one that I've experienced, complex queries affect significantly program speed. I've found that several simple queries are substantially faster that one complex query.

 

[wizcow2]

Another action that may help, is to compile your code.

Open the VB window, in the menu select 'debug' >> 'compile'

Tom

 

[Rich]

Have you tried running the built in analyzer ?

 

[Annabelle]

I am not familiar with a built in analyzer.

 

[wizcow2]

Annabelle

In your main menu select
Tools>>Analize>>Performance

Tom