Hi jojo
>We'll the other suggestions are good, and your method is a nice idea. My practice of connecting and disconnecting when doing an insert,update, delete or queries was base on my web database application development which I also practice in my VFP programming when it comes to Client/Server application.
Thanks. Glad you liked the idea, see David's post in regards to such an idea it is much clearer.