LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-25-2006, 11:33 PM   #1
Old_Fogie
Senior Member
 
Registered: Mar 2006
Distribution: SLACKWARE 4TW! =D
Posts: 1,519

Rep: Reputation: 62
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.
 
Old 07-26-2006, 12:49 AM   #2
jens
Senior Member
 
Registered: May 2004
Location: Belgium
Distribution: Debian, Slackware, Fedora
Posts: 1,439

Rep: Reputation: 275Reputation: 275Reputation: 275
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.

Last edited by jens; 07-26-2006 at 01:03 AM.
 
Old 07-27-2006, 05:37 PM   #3
Old_Fogie
Senior Member
 
Registered: Mar 2006
Distribution: SLACKWARE 4TW! =D
Posts: 1,519

Original Poster
Rep: Reputation: 62
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 .
 
Old 07-27-2006, 06:04 PM   #4
jstephens84
Senior Member
 
Registered: Sep 2004
Location: Nashville
Distribution: Manjaro, RHEL, CentOS
Posts: 2,098

Rep: Reputation: 102Reputation: 102
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.
 
Old 07-27-2006, 10:38 PM   #5
Old_Fogie
Senior Member
 
Registered: Mar 2006
Distribution: SLACKWARE 4TW! =D
Posts: 1,519

Original Poster
Rep: Reputation: 62
Hi JS,

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
 
Old 07-27-2006, 10:51 PM   #6
rickh
Senior Member
 
Registered: May 2004
Location: Albuquerque, NM USA
Distribution: Debian-Lenny/Sid 32/64 Desktop: Generic AMD64-EVGA 680i Laptop: Generic Intel SIS-AC97
Posts: 4,250

Rep: Reputation: 62
http://www.linuxquestions.org/linux/..._Data_to_Linux

May be helpful, maybe not.
 
Old 07-28-2006, 12:06 AM   #7
jstephens84
Senior Member
 
Registered: Sep 2004
Location: Nashville
Distribution: Manjaro, RHEL, CentOS
Posts: 2,098

Rep: Reputation: 102Reputation: 102
Sorry Old_fogie I was reading pretty quick. Have you tried staroffice by any chance. Just wandering if it was any different from openoffice.
 
Old 07-28-2006, 12:43 AM   #8
jens
Senior Member
 
Registered: May 2004
Location: Belgium
Distribution: Debian, Slackware, Fedora
Posts: 1,439

Rep: Reputation: 275Reputation: 275Reputation: 275
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
database replication software test111 Linux - Software 1 08-30-2005 08:02 PM
Linex Driver / Software Database NeoRage LQ Suggestions & Feedback 3 11-08-2004 10:56 AM
Database software, equivalent to Access? nidputerguy Linux - Software 5 01-04-2004 06:54 PM
Gnome Database Software Gnustome Linux - Software 2 11-02-2003 01:53 PM
GIMP & image maps kurnow Linux - Software 1 01-21-2003 07:18 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:52 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration