MS Access Banking Solution

[mazubair]

I am going to develop a Banking Solution for very small branches of a
Bank. The branches are standalone and no remote transactions will be
made i.e. only the individual branch will be under networking and there
will be no networking between the branches. The branches have maximum
10000 (ten thousand) customer accounts, maximum 200 daily (60000
yearly) transactions and maximum 3 to 4 concurrent users. The solution
will provide voucher generation, interest calculation and interest
anticipation, batch posting etc. facility. The system will generate
over 100 reports, some of them are too complex (manipulate data from
several tables, calculate, summaries, make group etc.).

I intend to develop the solution with MS Access as Database, Visual
Basic as Tool and Crystal Report as Report Builder.

Should I ?

Proceed with the Idea.
Split the transactions Table for different types of Accounts. There
will be about maximum 40000 records yearly.
Split the Cheque (Account Wise of Year wise) information Table which
will store 500000 yearly records.
Some one are suggesting using different database for different types of
account. Should I go for that.
Your valued suggestion will help me a lot to take decision.

M. A. Zubair

Bangladesh

[Lyle Fairfield]

ma******@gmail.com wrote:

I am going to develop a Banking Solution for very small branches of a
Bank. The branches are standalone and no remote transactions will be
made i.e. only the individual branch will be under networking and there
will be no networking between the branches. The branches have maximum
10000 (ten thousand) customer accounts, maximum 200 daily (60000
yearly) transactions and maximum 3 to 4 concurrent users. The solution
will provide voucher generation, interest calculation and interest
anticipation, batch posting etc. facility. The system will generate
over 100 reports, some of them are too complex (manipulate data from
several tables, calculate, summaries, make group etc.).

I intend to develop the solution with MS Access as Database, Visual
Basic as Tool and Crystal Report as Report Builder.

Should I ?

Proceed with the Idea.
If I were President of the any of the banks, it's unlikely that I would
approve of the use of JET (Access) as the database for the financial
transactions. I have little or no confidence in the security of this
technology against any determined and skillful attack.

If I were you I would consult a reputable lawyer about my liability
should the security of the system be broached and money stolen.

I think I am voting, "No", to proceeding with the idea here, but I
really do not have sufficient appreciation of the facts of the situation
to do so.
The weakest part of Access-JET may be JET. If you MUST go this way,
perhaps, you could consider Access for your user interface and MS-SQL
for your database.
Split the transactions Table for different types of Accounts. There
will be about maximum 40000 records yearly.
No.
Split the Cheque (Account Wise of Year wise) information Table which
will store 500000 yearly records.
No.
Some one are suggesting using different database for different types of
account. Should I go for that.
No.
Your valued suggestion will help me a lot to take decision.
It seems by the suggestions that you have received that the banks are
not over-flowing with database experts. I can understand that the
development budget may be low but have you considered purchasing a
shrink-wrapped solution, or hiring someone who has successfully created
something similar in the past?
M. A. Zubair

Bangladesh

--
--
Lyle

"The aim of those who try to control thought is always the same. They
find one single explanation of the world, one system of thought and
action that will (they believe) cover everything; and then they try to
impose that on all thinking people."
- Gilbert Highet

[Tom van Stiphout]

On 30 Apr 2005 03:00:11 -0700, ma******@gmail.com wrote:

If my bank were to build its accounts software on MsAccess (a Jet
database), I wouldn't know how quickly to take my business elsewhere.

-Tom.

I am going to develop a Banking Solution for very small branches of a
Bank. The branches are standalone and no remote transactions will be
made i.e. only the individual branch will be under networking and there
will be no networking between the branches. The branches have maximum
10000 (ten thousand) customer accounts, maximum 200 daily (60000
yearly) transactions and maximum 3 to 4 concurrent users. The solution
will provide voucher generation, interest calculation and interest
anticipation, batch posting etc. facility. The system will generate
over 100 reports, some of them are too complex (manipulate data from
several tables, calculate, summaries, make group etc.).

I intend to develop the solution with MS Access as Database, Visual
Basic as Tool and Crystal Report as Report Builder.

Should I ?

Proceed with the Idea.
Split the transactions Table for different types of Accounts. There
will be about maximum 40000 records yearly.
Split the Cheque (Account Wise of Year wise) information Table which
will store 500000 yearly records.
Some one are suggesting using different database for different types of
account. Should I go for that.
Your valued suggestion will help me a lot to take decision.

M. A. Zubair

Bangladesh

[Alan Webb]

Mazubair,
I'm with Lyle on this. The volume of data is big enough, the likely growth
in concurrent connections large enough, and the need for security strong
enough, that Jet/Access will be more trouble than it is worth. In order of
preference: a packaged solution from a vendor that has been in business for
a while and has an established reputation for reliability, a mix of packaged
and custom solutions using a reporting tool like Access or Crystal Reports,
rolling your own in something like PostgreSQL or SQL Server. This to me is
a strong candidate for buy instead of build.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS
<ma******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I am going to develop a Banking Solution for very small branches of a
Bank. The branches are standalone and no remote transactions will be
made i.e. only the individual branch will be under networking and there
will be no networking between the branches. The branches have maximum
10000 (ten thousand) customer accounts, maximum 200 daily (60000
yearly) transactions and maximum 3 to 4 concurrent users. The solution
will provide voucher generation, interest calculation and interest
anticipation, batch posting etc. facility. The system will generate
over 100 reports, some of them are too complex (manipulate data from
several tables, calculate, summaries, make group etc.).

I intend to develop the solution with MS Access as Database, Visual
Basic as Tool and Crystal Report as Report Builder.

Should I ?

Proceed with the Idea.
Split the transactions Table for different types of Accounts. There
will be about maximum 40000 records yearly.
Split the Cheque (Account Wise of Year wise) information Table which
will store 500000 yearly records.
Some one are suggesting using different database for different types of
account. Should I go for that.
Your valued suggestion will help me a lot to take decision.

M. A. Zubair

Bangladesh