Access vs VB

Hi All,

I am currently programming applications in VB6 and MSAccess, my employeer wants me to choose between the two.

Which one would you prefer, regarding stability and packaging etc.

If I choose Access, then everything would be in Access,
but if I choose VB, the DB will be in Access and the forms and code in VB6.

Any suggestions?

Regards

.NET
But if you have to choose between either VB6 or Access, I would go with VB6.

Thanx,

but how difficult does the packaging become with compatibilty across all windows platforms and dll's that need to be registered(.Net or VB6)?

Distribution of an access-based app is difficult unless you are sure all target computers have the same version of Access installed.

A good installer package makes it easy to distribute VB6 apps. I use the free Visual Studio Installer and have distributed apps that use many components to all versions of windows, and haven't had any problems.

What database would you use with your vb app?

If i am going to use a access database, would I not need the access component, or is the MS Access Driver installed with any windows version?

If you're going to use a db with a vb app, you'll probably want to use ADO, so yes you'll need ADO installed on the target computer. MDAC has been included in windows from W2000 on, MS offers a downloadable installer that, with some work, you can include as part of your setup program.

You don't need access itself to be installed on any target computer unless you intend to instantiate Access itself from your code so you can use a report or something.

Thanx Doug,

VB it is then