VB or Access

  • Thread starter Thread starter Derek
  • Start date Start date
D

Derek

Hi

Very generally what are the advantages / disadvantages of
writing applications in VB as apposed to access
 
Access is intended to be used with databases. The controls are all bound,
and work with your data. If you're working with data, it's usually
considerably faster to develop an application using Access instead of VB.

Unless all of your users have Access installed, however, distributing an
Access application can be more problematic than distributing a VB
application.
 
Funny, when answering this kind of question a few years ago...my post would
be "HUGE".

It turns out that Douglas answer in the other post is really about the right
short answer.

So, VB is better is you need to distribute your application (to users you
will never see).

Also, VB has much better support for activeX controls (so, if you need
sliders, spinners etc, treeviews), then again, VB is much better

Access is better for data centric applications. Often, we call them CRUD
(create, read, update, delete).

Also, ms-access has a real nice tight integration with the report writer. I
have to admit, that the report writer is STILL one of the best in the
industry..and yet is now 10 years old.

Also, both forms, and reports in ms-access has what is called sub-form, or
sub-reports. This "concept" closely follows and models the classic one to
many relationships that are the very essence of a relational database
applications. So, in this regards..ms-access really shines.

If your application is some basic thing like "job costing", or building
quotes etc, then ms-access can easily cut your development time down by 1/2
or better when compared to VB. Event the listbox and combo box controls in
ms-access are far better then the standard vb ones. (here is some screen
shots of grids in ms-access)

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

So, VB is a general development tool, and you can even makes games with
VB...but this would be silly with ms-access.

They are different tools, and want to pick the right tool for the right job.
 
Thank you both.

That's the kind of information that you could spend a year
finding out the hard way. Brilliantly simple over veiw.
Just what I wanted.
 
Back
Top