Has anyone got any ideas how I could speed up my application.
It is shared over a network and is in Access 97.
The logon has a lot of code which I have tried to make as efficient as possible.

Is there a way to detect if the app is still loading because that is what I think is causing the delay.

On my computer it is sometimes quite fast but for other users it can be really slow.
Sometimes well over a minute wait after the logon ok click.
I have tried compiling all modules but it is still slow.

Even if I could display to the user that the app is still loading while detecting it loading and then when it is finished start the main database so it increases speed of my db.
This would show the user what is going on, currently the wait has no explaination.