Functionality. Access or Visual Basic

[Relg]

I am starting a new db shortly. I was wondering whether more functionality is produced through a visual basic frontend or an access developed one?. Which method is beteer for providing more flexibility and scalability.

thanks.

relg

[Beacon]

VB!

Too many reasons to list...
But flexibility and scalability = yes and yes!

good luck.

[shragel]

VB is better trhu its GUI Alone

[Nucleus]

shragel, a lot of the Access controls have more functionality than the equivalent control in VB, for example show me the multicolumn combo or the subform in VB?

I would say Access has a much better gui for DBs to get things up and runnning fast. BUT, the database is only a toy database, not true client server, and cannot be scaled, so get used to VB if you can. Start with VB and Access back end. Then migrate to using SQL server back end. Oh yeah, you will have to learn crystal reports too.

Only go Access GUI if time is short and max users <10.

[Ernst Preuss]

If you are writing a commercial package or for heavy multi-user envirement.. VB is your only choice.

If it's an in-house app with only a dozen users or so at any one time then you can knock up something snazzy in Access in no time flat!

If your new to visual programming in general, then six months in Access is a gentle learning curve into VB at a later date.


enjoy.....