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

[anwar jamil]

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

[Serge]

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
Serge_Dymkov@vertexinc.com
Access8484@aol.com

[JHausmann]

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.

[SmithVoice]

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