×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Best database software?

Best database software?

Best database software?

(OP)
A project has been highlighted to myself in my company, that will evolve into a major database operation that in essence will be the central database for the company.  They ahve asked my opinion about what package to use, bearing in mind that most users will have MS Access (probably 97 version).  I personally think it needs something more than Access, and am wondering what opinions you have?  Maybe are there packages out there that can have Access interfacing into them?  Or would it be best for it to be programmed in something more indepth than access and then a small program for all users be palced on their machines?  

Opinions and info please?

Kind regards

Thank you for your help already.

Matt Pearcey

RE: Best database software?

As far as I know Access can connect fairly readily to any number of backends, though in my experience Access 2000 is better at it than Access 97.

What's their budget and/or what database backends do they have available now?

Ben
+61 403 395 052

RE: Best database software?

Central Database, many users, increased network trafic, forget about desktop systems like access, paradox, dbase etc.

Start thinking about a client-server system. The options are:

If you like Microsoft:

Database  : SQL-server (Microsoft)
interface : VB, VC++,   (Microsoft)
           Delphi (Borland)

You will need a NT server to run SQL-server


If you got money

Database: Oracle
interface:  Oracle Forms
            VB, VC++, Delphi
Need some heavy hardware to run Oracle database


If you want a free Database

Database: Interbase (Borland) opensource
interface: Delphi

Hardware, the database can run on a Win98, NT workstation or Linux platform.

There is also MYSQL which runs on linux, but i do not have experience with it.

Allmost all of the programming tools, Delphi, VB, VC++ can interface with the Databases. Microsoft uses ODBC and Borland use the BDE engine with its own drivers.

I personally do not like interfacing with access, because in most cases you copy data from the server to access (double work).

There more options, but I prefer the couple Interbase x Delphi, although you can use VB and VC++ also.

Regards






S. van Els
SAvanEls@cq-link.sr

RE: Best database software?

Access 2000 when linked to SQL Server doesn't have the usual Access problem of needing to grab all the tables a query may want and then filtering - it can actually send just what you want.

However depending of how complex the user interface needs to be I would probably suggest a web frontend.

Ben
+61 403 395 052

RE: Best database software?

I agree with the gentleman above that Access isn't going to suit your needs for this project.  If you are familiar with Access, you've probably worked with Visual Basic.  So I'd recommend you go with using SQL Server 7.0 or later as your RDBMS database server and using either Visual Basic or Access 2000 as your front end.  What I often do is build the prototype application in Access and then upsize it to SQL Server.  The upsizing wizard that comes with Access 2000 is a snap to use and migrates all the tables and relationships to SQL Server and then creates the links to those tables.  You can then create forms and reports off of these linked tables from within Access!  I'd suggest getting the Sams book on making this happen.  I think this is a great solution for your environment.  Oracle is too expensive unless you have a humungous database on the internet.  Forget about this Interbase.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close