>It did finally work but took a long time. Is there anyway that I can determine what it's doing such that I can try to speed it up? That is (e.g. indexing)
>Thanks
>Jerry

If you start the application with the indexing, you need to give some indication to your users at least.

Something like

wait window nowait 'Please wait. Reindexing tables...'
indexing code
wait clear

Also you don't need to re-index every time you start the application. You can do this once in a month.

You can post some of your code so we may try to give optimization ideas.