Re: Ad Hoc Query Tools

Clay Amerault wrote: > > The users are used to using Microsoft Access, and want the ability to > build queries through a drag and drop GUI. The database tables > (approximately 75 of them) are small, under a thousand rows in most > cases, and with a 2K row size. One table will be 500,000 rows, with a > 2K row size. [...] Ahh, thanks for the clarification. With this, there are many out there on the market today. All of them, no matter what they say require the user to have some knowledge of databases and how the data goes together (so that someone doesn't make a request that generates a humongously slow query that blocks out other processing, for instance). Crystal Reports is a very popular product at this time for what you want, but I don't know if it has anything to do with java in its current incarnation. I have found that in most of these products, you get what you pay for. -/Renegade