|
Need two software reccomendations please, maps & database
Hi all,
I was wondering if there is gnu/linux comparable version of: 1. MS Streets & Trips 2. MS Access. Yes I know there is open office for the database, however it does not have the encryption of the database and/or light duty ms-jet style engine for small lan traffic hosting, or the front end controls building tools that I need. Or if anyone has a link to maybe a good software web-site that cross-references win32 app's to gnu/linux that would be great. Thank you in advance. |
1. MS Streets & Trips
I'll have to admit, it's probably the best of its kind. This is a hot topic on the wine dev list and will most likely run on linux in the near future. I did got it working once, but the many kernel-patches I needed broke the rest of my system. Just be patient, eventually it will work under Wine. Until then, try this: http://www.gpsdrive.cc/index.shtml 2. MS Access I really dislike it and fail to understand what it's good for. I personally only make use of external databases. Could you be more specific in what you need it for? MS Access also works fine in CrossOver Office if you really need it. |
Hi jens,
Thank you for the info on gpsdrive. Regarding access, basically I'm looking for some database that is able to handle about 20-25 tables, most of the tables are under 100 or so rows deep. However there are probably about 5 tables which are in the thousands. I need a database that can probably handle relationships to about 5 levels deep. That is one table has embedded about 5 relational primary key's. I'm looking for a way to make a front end kind of like what access allows you do with your forms. Make buttons to run pre-made active-x type of controls (or linux equiv) to allow users to push buttons to run pre-made routines. Query the database, print out pre-made forms, reports etc at the push of a button. the ms-jet reference i made is that simply access includes it's own way to make a back-end (to store your tables) and a front end that the various users on a lan use (graphical interphace) to access and query the database as need be. Probably what I'm looking for in simple terms is a database solution that is sufficient for a small company (e.g. 8 or less users) but flexible enough for a small company to admin without the need to run a designated high end server. The database is for tying in orders, inventory and crm. But the company doesn't want or need a full all out proprietary or pre-canned solution. It really prefers built from the ground up. The database is only on during normal hours of business. When the office is about to close, the owner likes to back up the entire back end of the database and take it home - just in case. So he likes the fact that Access can encrypt it's back end when it's not on. they also like that access has a re-build tables and relationships function in there in the event the pc crashes and tables can get corrupted. MS access was able to deliver that but the company is going to gnu/linux now and looking to get off the MS office schema. Hope that explains, it's kind of tuff to put into words . |
OpenOffice has a program called base that can create front end apps like access. Have not had much time to use it but played with it and do think it has potential. Might give it a try.
|
Hi JS,
:D my first post said yeah I know of open office... LOL it's ok. You're right tho, I looked there first to be honest. I started playing with it, actually sat down and starting hacking out a DB on it. But it's missing the encryption. It has xml and all they claim on a small line is that it's secure and no data to elaborate on why. I found the tools, well, I dont want to offend them, but the OO Database is not even on par with windows 95. Maybe they offer more in their pay version, but I'd like to stick with open source, and give back once I learn it. I've been doing databases long time, and think I could help on the project. I'll probably look into helping openoffice, but first I gotta get a database up for these people :D |
|
Sorry Old_fogie I was reading pretty quick. Have you tried staroffice by any chance. Just wandering if it was any different from openoffice.
|
Well, I'm really no expert in whatever either OOo or Access do, but IMO the biggest problem with OOo2 is indeed it's build-in(Base) database (HSQLDB). I think it's mostly build for users without any database skills. OOo can be easily connected with about all others like mySQL (using unixODBC or JDBC) though. I use OOo1 like this and even that is much more functional as OOo2 with only Base.
Also give a look at Kexi and Rekall (both can use external databases as wel): Kexi: http://www.kexi-project.org/ Rekall: http://www.rekallrevealed.org/kbExec.py |
| All times are GMT -5. The time now is 06:45 AM. |