Visual Basic OR Access is better for this application ?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

We are going to develop a database for Library Ticket
Database with the following requirement
1) Different User Interface with Different User Types
(There are totally 4). Users with individual logins will
be assigned to corresponding User Types.
2) Aduit Log is required
3) There are a number of validation rules when user
inputting data (Like - Different Kind of Books / Different
type of borrowers have different loan period)
4) Maintenance of Code Tables

We would like to know whether VB or Access VBA is
preferred ?
 
Tom said:
We are going to develop a database for Library Ticket
Database with the following requirement
1) Different User Interface with Different User Types
(There are totally 4). Users with individual logins will
be assigned to corresponding User Types.
2) Aduit Log is required
3) There are a number of validation rules when user
inputting data (Like - Different Kind of Books / Different
type of borrowers have different loan period)
4) Maintenance of Code Tables

We would like to know whether VB or Access VBA is
preferred ?
Click to expand...

Preferred by whom? 10 to 1 a VB programmer will prefer VB (at least until
he's used Access for a few databases) An Access programmer will prefer
Access. I program in both and in other Office apps and I tend to prefer
Access for databases because it is at least 3 times faster to build
databases with. Access is designed for one purpose: building databases. VB
is a general purpose programming language that does a nice job of databases,
but lacks about 40% of the database-centric events, methods, and properties
built into Access.

In the end, if you're comfortable with VB and don't know Access, use VB,
otherwise use Access.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
It is not always such a easy answer.

Much will depend on the skill of the developers. If you have a good skilled
ms-access developer (good with vba, and sql), then most certainly ms-access
is the way to go. If you have a developer with good VB skills, but not
having used ms-access, then the VB developer will be better.

If you are able to "choose" a developer for either platform, then likely
ms-access will be less cost. The bottom line here is going to be how skilled
the developer is in what platform (the skill and knowledge of the developer
will really dictate this choice).

You can't spend a year learning one platform, or the other platform because
you like a particular devilment tool. However, if you have a choice of two
good developers (one VB, and one ms-access/VBA/sql skilled, then I am
betting on the ms-access developer).

There is also the distribution issue, and in that regards, VB is somewhat
better if you are going to distribute the application to a large number of
users/pc's.
 
Back
Top