Re: [gentoo-user] data base program
2005/12/21, Ryan <[EMAIL PROTECTED]>: > Here is a little trick you can use on google when looking for > converters.. Put the file extension of the file you want to convert in > front of the number 2. Like this: mdb2, and if you know the file > extension of the target, add that AFTER the 2. Like this: mdb2mysql or > mdb2sql. This is not always going to work, but try it anyways and look > at the 1st result in google. These will both bring up hits for what you > are lookin for, but try mdb2mysql first as it's more descriptive. Most > GPL'd converters will use this type of format (rpm2tgz comes to mine > hehe). But there are some commercial apps that have caught on and named > their apps in that same naming convention. > > > http://www.enobis.com/sw/mdb2mysql/ > Thank you very much. -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] data base program
Here is a little trick you can use on google when looking for converters.. Put the file extension of the file you want to convert in front of the number 2. Like this: mdb2, and if you know the file extension of the target, add that AFTER the 2. Like this: mdb2mysql or mdb2sql. This is not always going to work, but try it anyways and look at the 1st result in google. These will both bring up hits for what you are lookin for, but try mdb2mysql first as it's more descriptive. Most GPL'd converters will use this type of format (rpm2tgz comes to mine hehe). But there are some commercial apps that have caught on and named their apps in that same naming convention. http://www.enobis.com/sw/mdb2mysql/ capsel wrote: OpenBase is part of OpenOffice... and is really slow on my laptop. Whole OpenOffice is slow... So I'll try that GUIs for mysql. Do you know any replacement of OpenOffice for my laptop ? :) BTW. Is there a tool to convert mysql (and possible other) databases to and from ms-access *.mdb's ? -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] data base program
On Tue, 20 Dec 2005 14:42:00 +0100, Hans-Werner Hilse wrote: > OK, please don't try to enforce your own name... it's OpenOffice Base, > not OpenBase, as you've been told... If you're going to be pedantic, it is OpenOffice.org Base. -- Neil Bothwick I never forget a face, but in your case I'll be glad to make an exception. signature.asc Description: PGP signature
Re: [gentoo-user] data base program
Hi, On Tue, 20 Dec 2005 13:45:19 +0100 capsel <[EMAIL PROTECTED]> wrote: > OpenBase is part of OpenOffice... and is really slow on my laptop. OK, please don't try to enforce your own name... it's OpenOffice Base, not OpenBase, as you've been told... > Do you know any replacement of OpenOffice for my laptop ? :) koffice, probably. Or a combination of gnumeric/abiword, possibly. > BTW. Is there a tool to convert mysql (and possible other) databases > to and from ms-access *.mdb's ? There's an ODBC connector for MySQL, yes. You can use mysql tables in MS Access this way. -hwh -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] data base program
OpenBase is part of OpenOffice... and is really slow on my laptop. Whole OpenOffice is slow... So I'll try that GUIs for mysql. Do you know any replacement of OpenOffice for my laptop ? :) BTW. Is there a tool to convert mysql (and possible other) databases to and from ms-access *.mdb's ? -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] data base program
James Ausmus wrote: >On 12/19/05, capsel <[EMAIL PROTECTED]> wrote: > > >>Is there any program for makeing data bases as fast as ms access >>(works fast, small) and free as openbase? >> >> > >I haven't used it much, just looked at it a time or two, but Rekall >aims to be a MS Access work-alike replacement tool - it runs on top of >a MySQL or Postgresql database - it just provides the "pretty" UI >elements such as forms, reports, visually-designed queries, etc. > > You can also use Open Office Base, which is the data basing component of Open Office. I have it set up with an ODBC connection to a MySQL database (because Open Office didn't have a database component until recently). You can use it to create forms (for example, to create a list box from which to select values for certain fields) and edit the database from within the form. Any changes are saved in Open Office as well as back to the MySQL database. Gentoo has a MySQL startup guide if you have never used it: http://www.gentoo.org/doc/en/mysql-howto.xml To set up the ODBC connection (note that this document was written prior to Base being part of Open Office, but the methodology for setting up the ODBC connection still applies - except that in Gentoo the odbc.ini and odbcinst.ini are in /etc/unixODBC/ and the correct file name for the library is /usr/libmyodbc3.so): http://www.unixodbc.org/doc/OOoMySQL9.pdf Regards, Colleen -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] data base program
On 12/19/05, capsel <[EMAIL PROTECTED]> wrote: > Is there any program for makeing data bases as fast as ms access > (works fast, small) and free as openbase? I haven't used it much, just looked at it a time or two, but Rekall aims to be a MS Access work-alike replacement tool - it runs on top of a MySQL or Postgresql database - it just provides the "pretty" UI elements such as forms, reports, visually-designed queries, etc. -James -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] data base program
The very newest version of OpenOffice (2.0.x) has this ability. This is a great way to go if you couple it with a Mysql or PostGress database server. But it can also use it's own little standalone DB if you dont have access to a server. The Forms editor is probably what you are looking for since you mentioned MS Access, and OpenOffice has exactly that. I suggest OpenOffice w/Mysql if at all possible. You'll get blazing speeds if you do it that way. capsel wrote: Is there any program for makeing data bases as fast as ms access (works fast, small) and free as openbase? On OpenBase process of opening a wizard for form took more than 8 minutes!! I've got only 128 MB of ram. -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] data base program
On 2005-12-20 00:24 +0100, [EMAIL PROTECTED] wrote: > Is there any program for makeing data bases as fast as ms access > (works fast, small) and free as openbase? I am not familiar with OpenBase, but Kexi and OpenOffice.org Base come to mind as general-purpose alternatives to Microsoft Access. -- Michael Kjörling, [EMAIL PROTECTED] - http://michael.kjorling.com/ * ASCII Ribbon Campaign: Against HTML Mail, Proprietary Attachments * * . No bird soars too high if he soars with his own wings . * pgpz4jskvDmAB.pgp Description: PGP signature
Re: [gentoo-user] data base program
On Monday 19 December 2005 17:24, capsel <[EMAIL PROTECTED]> wrote about '[gentoo-user] data base program': > Is there any program for makeing data bases as fast as ms access > (works fast, small) and free as openbase? Access sucks as a database. Eventually, you'll want to use a real database like mysql, postgres, oracle, db2, or sybase. My personal recommendation is postgres, at least until you've outgrown it, and then db2. > On OpenBase process of opening a wizard for form took more than 8 > minutes!! I've got only 128 MB of ram. When you say OpenBase, do you mean Base from OpenOffice.org 2? If not, I suggest trying it out. I never have but I've heard it supposed to replace Access. In any case, you might try mysql + DBDesigner. I think DBDesigner is supposed to have support for other DBs, but I didn't figure that much out about it. -- Boyd Stephen Smith Jr. [EMAIL PROTECTED] ICQ: 514984 YM/AIM: DaTwinkDaddy -- gentoo-user@gentoo.org mailing list