>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.
If it's not broken, fix it until it is.
My Blog