Ms Access database versus specialised one written in Delphi 
Author Message
 Ms Access database versus specialised one written in Delphi

Who knowes from experience and knowledge why it is usually better to write
a specialised database system using e.g. delphi compiler, in comparison
with programming Ms Access universal database system according to the user
needs? I know that Ms Access allows defining various procedures in, as far
as I remember, Visual Basic or Access Basic, and assigning them to buttons
clicking in the way similar to how Delphi components work. I would like to
know if using Delphi
 (1)allows simplier programming of the kind
 (2)more universal programming, that is the application has  (compared with
Ms Access) more function of database access etc. which is often or usually
required by the user
 (3) something else that I do not know (please tell me what it is)

Please give me some simple examples for (1) and (2) and answer (3)



Wed, 18 Jun 1902 08:00:00 GMT  
 Ms Access database versus specialised one written in Delphi
On Mon, 29 Mar 1999 14:49:46 GMT, "Mariusz Jdrzejowski"

Quote:

>Who knowes from experience and knowledge why it is usually better to write
>a specialised database system using e.g. Delphi compiler, in comparison
>with programming Ms Access universal database system according to the user
>needs? I know that Ms Access allows defining various procedures in, as far
>as I remember, Visual Basic or Access Basic, and assigning them to buttons
>clicking in the way similar to how Delphi components work. I would like to
>know if using Delphi
> (1)allows simplier programming of the kind

Simple things can be done more easily in Access than Delphi.

Quote:
> (2)more universal programming, that is the application has  (compared with
>Ms Access) more function of database access etc. which is often or usually
>required by the user

Delphi allows you to access different types of dbs.  Access also can,
but only through ODBC.  Delphi gives you better control on events.
This makes it more powerful, as you can add custom code in more places
to do more complex things.

Quote:
> (3) something else that I do not know (please tell me what it is)

Delphi is extendable.  You have access to the VCL (the Borland class
library which encapsulates most of the standard Windows objects).  It
is all written in Object Pascal and, if you buy the Pro or C/S
edition, you get the VCL source code.  You can use shareware or
freeware components to make it do almost anything you want, and if
that isn't enough, you can build your own.

Delphi has its own object oriented language (Object Pascal) you can
use to create your own classes.  I know many are not keen on OOP, but
if you are, then you need a real OO language.

Another thing is Delphi produces real exes and dlls.  Access puts
source in the db, even though it has some primitive form of
protection.  Apart the speed issues, Delphi provides a better way to
deploy professional apps.

This is just some fast considerations.  I use Access for simple things
I use in my firm, like invoices (100 a year) and resource tracking.  I
also use Access for fast apps I every now and then build for my mother
and other parents.  I also sometimes use it for simple customer apps
(reports and dbs with few tables, maybe reading external data).  I use
Delphi to do all the other professional things.

Access is a good substitute for the old DBase, whereas Delphi is a
good substitute for old Clipper.

In big firms, you'd expect many employees to be able to use Access
(without programming though) for reports and simple data entry.  If
you are a consultant then you're expected to be able to use either
Delphi or some other full-featured language (like VB) to produce
professional apps.

....zzziipp (flame suit ON)

Regards,

--
Marco Rocci
MicroEra srl
Turin, Italy



Wed, 18 Jun 1902 08:00:00 GMT  
 Ms Access database versus specialised one written in Delphi

Quote:

> This is just some fast considerations.  I use Access for simple things
> I use in my firm, like invoices (100 a year) and resource tracking.  I
> also use Access for fast apps I every now and then build for my mother
> and other parents.  I also sometimes use it for simple customer apps
> (reports and dbs with few tables, maybe reading external data).  I use
> Delphi to do all the other professional things.

> Access is a good substitute for the old DBase, whereas Delphi is a
> good substitute for old Clipper.

> In big firms, you'd expect many employees to be able to use Access
> (without programming though) for reports and simple data entry.  If
> you are a consultant then you're expected to be able to use either
> Delphi or some other full-featured language (like VB) to produce
> professional apps.

> ....zzziipp (flame suit ON)

I don't think you need to put on your asbestos bunny-suit for saying
that, Marco.  Although you obviously should be using Paradox ;-) ;-) ...
no, seriously, you're right.  

A system like Access is a large (and getting larger all the time)
application built on top of a database engine that is well-suited to
many types of business applications.  If it is the simplest and most
expedient way to get the job done then there is no reason to do the same
thing in Delphi.

But I've seen firsthand, and lost tens of thousands of dollars in 'real'
money to, what happens when MS-Access is *not* the right tool for the
job and you cannot circumvent its built-in limitations to make the damn
thing work.

If what you need to do can be done in Access then it will be many times
more expensive to do the same thing in Delphi.  But if the job cannot be
done in Access then Delphi will produce the intended application and it
will run like a sonofa{*filter*}.  ;-) ;-) ;-)



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. MS Access 2.0 versus Delphi 3.0

2. Accessing a MS Access Database with Delphi 4

3. Accessing MS Access database with Delphi application

4. Accessing MS Access database with Delphi application

5. V.C++ versus V.Basic versus Delphi

6. Deploying delphi app with MS Access database

7. URGENT Writing the contents of data-aware controls to the database TOUGH ONE

8. Deleting a detail record using Delphi 1.0 on a MS Access 2.0 database

9. Delphi & MS Access database(multi-user)

10. How to use a MS-Access-Database with Delphi 4

11. Opening database (developed by Delphi) in MS Access

12. Reports in Delphi 4 with native MS Access Database

 

 
Powered by phpBB® Forum Software