--- "Peter Bower, M.D." <[EMAIL PROTECTED]> wrote: > I am reading and writing to an access database using > revolution. > All seems to go well, then after 10 transactions I > get a "(ODBC Microsoft Access Driver) too many > client tasks" error. > After each open command to read or write to the > database I always have a close statement. > > Any thoughts as to what I'm doing wrong? > > Peter J. Bower, M.D. >
Hi Peter, What exactly do you close? The connection? Or the result set cursors? You don't have to close the connection after each query, but you should always close the cursor before executing another query. Jan Schenkel. Quartam Reports & PDF Library for Revolution <http://www.quartam.com> ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) ____________________________________________________________________________________ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469 _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
