Why to use V.B6.0 rather than using Access 97

What is the use of using V.B 6.0 rather than using Access 97 or any other database packages.

With VB you can compile your application to be a stand-alone executable, you can't do that in Access. You would always have to have Access install in order for you to access your forms.

Regards,

------------------

Serge

Software Developer
[email protected]
[email protected]

It's actually a good thing to have both. You can distribute MSAccess files (without the user having to have MSAccess) that can be used by VB.

However, as in the past, MS has put the 2 tools out of step with each other. Access2000 works with Jet4 and VB5/6 does not do the same intrinsically. If you ADO then you can Jet4 with VB4/5/6 but if your have any need for DAO (esp even limited needs for a datacontrol) then VB has to stay with Jet3x. Access2000 developers are still urged to use DAO under a number of circumstances and the same 'urging' applies to VB/VC jet developers. This is limiting because, technically speaking, VB is not yet Jet4 compatible.

Aside from that you just have so much more flexibility with VB than Access. Access is a great front end for Jet but it is *only* a front end for Jet, anything Access can do VB can do if you want it to .. but with VB you are not limited to just doing Jet database apps.

------------------
http://www.smithvoice.com/vbfun.htm