[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

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.
0
elise_r
Asked:
elise_r
1 Solution
 
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
 
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
shaneholmesCommented:
"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
 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now