On Nov 9, 10:36 am, SePp <C_o_z_..._at_gmx.de> wrote:
> Hi all
>
> I want to build an application with .NET Framework C#/ and Oracle as
> Database,
> or with Access as Frontend for Oracle.
>
> What are the advantages / disadvantages of these ways (security,
> speed, query, etc.) ?
> Which one would be your choice and way?
>
> Thank you very much in advance for your opinion.
>
> regards
> SePp
There are pros and cons ( as I am sure you will see in the numerous
other postings). Access (and virtually any screen/report builder) will
have performance issues over "straight C/C++/whatever. However, Access
is relatively "cheap" as screen/report generators go, and since it is
GUI/WYSIWYG you can put together an application quickly. If nothing
else, you can use it for prototyping and quickly refine your user
interface. Some people help alleviate the performance issues by
putting the most "recent" or more "actively accessed" information
copied to the local Access tables at regular intervals, then "batch"
the Oracle updates to run off hours. How well it would work depends on
your app requirements.
Received on Sun Nov 11 2007 - 09:15:23 CST
