Migrating from MSAccess

I have spent lot of time working with DB using Access  driver, but now our requirements have overgrown capabilities of Access, especially in multi-user tasks. I need to switch to something else that works better than Access, uses no BDE/ADO/DAO/ODBC connection, handles multi-user fine and supports full-featured SQL.
elise_rAsked:
Who is Participating?
 
shaneholmesConnect With a Mentor Commented:
"BDE/ADO/DAO/ODBC connection"

What type of conduit do you expect to use? If none of these.

How about MYSQL:

Using Delphi's dbExpress with MYSQL

http://www.mysql.com/



There is also DBISAM

www.elevatesoftware.com

You can make make large two tier apps with that, and it doesn't require and special drivers. Its conduit to the data is compiled right into your EXE, with little footprint.

Shane
0
 
arnie145Commented:
Definitively Oracle – it’s the most powerful.
0
 
georg44Commented:
I know Oracle is not bad :) but it costs a whole bag of bucks. I need something less expensive, without royalty fee.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
layned31Commented:
When I was walking myself through this choice I picked up Absolute Database from www.componentace.com; after free evaluation I understood that it can fully replace any other DB. Plus it has many extended useful features such as encryption and memory usage. It is especially good in handling frequently-queried tables.
Moreover they have a good support team that answers a question within half a day. When I meet a difficult place I ask ‘em and they write a demo for me which is actually code I need. Just don’t use it very often ;)
0
 
BJThomsenCommented:
You might wanna check out firebird http://firebird.sourceforge.net/ its an open source verson of Interbase.
0
 
DragonSlayerCommented:
Yea, FireBird is a good choice if you want opensource but with support for SP and Triggers (which mySQL doesn't have, yet)

Also check out the Embedded Firebird, which allows you to deploy your app without installing the whole Firebird DBMS package.
0
 
DelphianCommented:
DS:
The whole FB package.... 3.5 Mb... ;-))))

 elise_r :

You can access directly Firebird with:
Commercial ones:
--> IBO -- one of oldest and coolest component suite to Interbase/Firebird (www.ibobjects.com)
--> FIBPlus -- a newer suite, earned respect from community (http://www.devrace.com/en/fibplus/?r1=fibplus&r2=Direct_Link)

Free/Open Source
UIB -- a suite of components for Firebird/Interbase (http://www.progdigy.com/UIB/). They have also
 DBExpress drivers
Mercury Database Objects(MDO) -- brazilian opensource suite for Firebird/Interbase
 http://mdo.sourceforge.net/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.