Access or VB: It depends. For a small database (less than 50,000 records)
and for rapid development of forms, queries and reports, Access is best. VB
takes much more time to develop in. However, if you are working with an
extremely large database (or perhaps a non-database) and have the time, then
VB can certainly do things that Access cannot.
For databases I tend to write in Access: very fast development - both the
front-end and back-end. Once the users are content with the design (i.e.,
the program has remained static for a while), but the number of records is
rapidly climbing, then I will "upsize" the back-end onto SQL Server and
start working on a VB front-end. (The Access front-end will still work with
SQL Server until the VB front-end is completed.)
For non-database projects, probably best to stick with VB. VB creates an
executable file that can be installed on most PC's, whereas you need Access
or runtime-Access to run an Access application. Further, VB runs much faster
and consumes less RAM that Access.
---Phil Szlyk
Quote:
>I will need to make a simple managment
>application but i dont know what use: VBA-Access
>or Visual Basic.What is the best choice...please
>give me some advantages of using each one.
>Where can i find some information about this two
>topics.
>Thank You...
>Patricia Fernandes
>Portugal
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---