Access and VB

[HS1]

Hello all

Could you please tell me the advantages of using Visual Basic (VB) to create
application that using Access for database. I think that I can create a
database and manipulate the data using Access. I also can use Access to
create forms and print report as an VB application can do.

The reason is that I do not know I should use VB (with a Access database) or
only Access for developing an application using a database for a small
company. (of course, if I use Access, I still have to use some VB functions
that are built in Access).
Thank you
S.Hoa

 

[Douglas J. Steele]

VB doesn't require that each user have Access installed. Instead, you can
simply deploy your VB executable along with the Jet database, and you're
done.

However, Access is specifically designed for developing database
applications in. It typically takes much longer to develop an equivalent
application in VB than in Access. There is virtually nothing you can do in
VB that you can't do in Access.

 

[ScottK]

Doug,

There is a middle-ground solution: Develop in Access (faster) and
deploy with Run-Time (cheaper).

Development in VB is time-consuming. Deployment in Full Version of
Access is expen$ive as you would need a license for each machine that
will run the database.

You only pay for Run-time version of access once and can install on
all your machines. It is now a standard part of all our images.

-ScottK