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
3  5470  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
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
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*******@SPAMh otmail.com
"It's not IT, it's IS
<ma******@gmail .com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ashu |
last post by:
hi to all,
Please read the following ques. first.
assume that a bank maintains 2 kinds of accounts for
customers one called as
savings accounts & other as current account.
the savings account provides simple interest &
withdraw facilities but no check book facilities.
the current account provides check book facilities but
no interest.
|
by: John Phelan |
last post by:
I read an article by, by Mike Groh, in Access-VB-SQL Advisor Magazine,
Week 37 that concerns me quite a bit on distributing Access
Applications commercially.
First I need to describe a "commercial version" of my application that
I hope to distribute after completing all the beta testing:
A. It was developed using MS AccessXP Pro (developers edition),
B. It has a front end MyApplication.mdb and a MyAppBbackend_be.mde;
the front end is...
|
by: mazubair |
last post by:
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...
|
by: KnightKnives |
last post by:
Is there anyone out there who could help me find the resources I need in
order to make this application. I have done a lot of work with 2.0 engine
then upgraded to 97; now have 2003. I have struggled with coding in VBA and
know some VBA. Have bookkeeping degree but want to apply as much as I can
with the limited knowledge that I have with VBA. Just some basics would
help me. Also, I am new to this forum and new to using the net. I am...
|
by: Peter Chant |
last post by:
I'm considering setting a website up for a club. I do not plan the contents
to be for public consumption, but on the other hand I'm not going to have
anything on there that is confidential, that would cause a problem if it
went further.
The basic reason is for publicity of club events. I want to make it easy to
use. I suspect a login with a password would be too much effort for most
people. I also note that computer literacy is not a...
| | |
by: cj |
last post by:
Lets assume all calculations are done with decimal data types so things
are as precise as possible.
When it comes to the final rounding to cut a check to pay dividends for
example in VB rounding seems to be done like this
3.435 = 3.44
3.445 = 3.44
Dim decNbr1 As Decimal
|
by: Bernard D |
last post by:
Hi,
I'm using Access 97.
I can run a query that finds a number of records, I then need to
access these results to build a formatted text file containing all of
the results. There will be 25 fields per record and potentially any
number of records.
I would have liked to have just produced a report sent to file but
|
by: bprasanth |
last post by:
How can I access the one *.fmx (i.e Bankmain master form file) to another *.fmx(*.Bank_Transactions form) without specifying the full path of the form for example D:\Banking\BANKING.fmx . If any one know this please send me the full description as soon as possible.
B.Prasanth nair (Specialization in Oracle9i)
E-mail: bprasanth_nair@yahoo.co.in
|
by: agins |
last post by:
I have used nearly every version of ACT for more than 15-years.
Currently have 5,000 records in one database and the program seems
unable to smoothly handle that many. Am starting a new business that
will have perhaps 20,000 records and considering ACCESS (although I
dread the learning curve).
Does anyone have experience comparing the two? Does anyone know how
VISTA will interface w ith each?
Steve Agins
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
