Try http://www.agata.org.br/us/ for English versions of both windows and Linux versions.
We have been running the Agata Windows client to access MySQL databases rather successfully for several years and it seems to work fine. I expect we are not on the current version, however (will have to check when I get in the office). -phil J. Philip Miller, Professor of Biostatistics Division of Biostatistics Washington University School of Medicine Director of Biostatistics Core, Siteman Cancer Center Mail: Campus Box 8067, 660 S. Euclid Ave St. Louis, MO 63110 Physical Address: 3349 Barnard Phone: 314-362-3617, 314-362-3728 (fax) email: [EMAIL PROTECTED] web: http://www.biostat.wustl.edu/~phil - The materials contained in this e-mail are private and confidential and are the property of the sender. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this e-mail transmission in error, please immediately notify the sender. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Citek Sent: Sunday, November 26, 2006 19:27 PM To: Central West End Linux Users Group Subject: Re: [cwe-lug] Querying an MS Access DB stan reichardt wrote: > Robert Citek wrote: >> Hello all, >> >> I have a copy of an MS Access database on my Ubuntu 6.06 laptop and I'd >> like to query it. >> >> What tools have folks here used and would recommend? > > The functionality in OpenOffice.org is quite usable. > I've not had an Access DB file to use, but have used > it with dBASE files and spreadsheets. > >>> Connecting to existing databases in OpenOffice.org 2.0 >>> http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1162261,00.html >>> OOo's database is somewhat less than desirable. For example, while I can "connect" to an Access database and I can view all of the data in a table, I cannot query it. That is, I have not been able to run a simple SELECT query, whether I create it using the Wizard, the design view, or the SQL view. Maybe I'm overlooking something, but when I click on Finish, I expect the Wizard to save the query. Instead, pressing Finish does nothing. > There is another tool, as I recall, that is from Brazil > called Agata Report, which is very much like Crystal Reports. > Unfortunately the documentation is only in Portuguese at this > point and I'm not sure that it directly supports Access DB files, > but may thru ODBC shims. The screen shots show it to be quite > mature and powerful, but as I indicated there is no English > documentation. > >>> http://www.agata.org.br/ Interesting. Worth a look. Thanks, Stan. Regards, - Robert _______________________________________________ CWE-LUG mailing list [email protected] http://www.cwelug.org/ http://www.cwelug.org/archives/ http://www.cwelug.org/mailinglist/ _______________________________________________ CWE-LUG mailing list [email protected] http://www.cwelug.org/ http://www.cwelug.org/archives/ http://www.cwelug.org/mailinglist/
