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 transactions
(120000 yearly including processed transactions i.e. interest, charges
etc.) 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.).

The expertise level of the user of the solution is very low. High end
Database will not be suitable for them.
I intend to develop the solution with MS Access as Database, Visual
Basic as Tool and Crystal Report as Report Builder.
Should I ?

1) Proceed with the Idea.
2) For better performance should I split the Transactions Table for
different types of Accounts. There will be maximum 200000 records in
whole yearly.
3) Split the Cheque information Table (Account Type wise or Year wise)
which will store 500000 yearly records.
4) Some one are suggesting using different databases for different
types of account. Should I go for that.
Your valued suggestion will help me a lot to take decision.
M. A. Zubair
ma******@gmail.com

[Mike MacSween]

<ma******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.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 transactions
(120000 yearly including processed transactions i.e. interest, charges
etc.) 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.).

The expertise level of the user of the solution is very low. High end
Database will not be suitable for them.
I intend to develop the solution with MS Access as Database, Visual
Basic as Tool and Crystal Report as Report Builder.
Should I ?

1) Proceed with the Idea.

No

MS Access is a great tool for small workgroups, and is a great deal better
than some people say.

But for an application where (I assume) security is vital it is not
appropriate. By security I mean both in terms of access rights and in terms
of integrity of data.

As a possible front end to a true server database, perhaps MS SQL Server,
then that might be a good approach, but at the actual data store itself,
forget it.

Just to re-iterate. MS Access is essentially 2 tools -

1. a user interface development environment geared to work with (amongst
others)..

2. a data storage engine, Jet.

Mike

[mazubair]

Hi Mike MacSween,

Thank you for your opinion.

Zubair