Link to home
Start Free TrialLog in
Avatar of 940216td
940216td

asked on

ACCESS OR PARADOX

I need to write a program to enroll students and we have doubts of the kind of database we should use.Access or paradox. Which is the fastest and gives the best performance with queries? Any comments, suggestions and tips will be appreciated a lot. Thanx Tom.
ASKER CERTIFIED SOLUTION
Avatar of marko020397
marko020397

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jic
jic

Marko, From what I remember, Access is faster than Paradox.  The issue here is that since we are working out of Delphi, then Access databases will be accessed via ODBC, where Paradox tables will be accessed through the BDE.  In this case, the BDE will be faster.  

On the other hand, if you get yourself a BDE replacement, then Access tables may be faster.
If you want to create a small database i would recomend you to
use access. If you want to make a profesional database use
paradox or interbase. It will work much and much faster.

Access is still an 'office' tool and not a prof. database.