"MontainDoctor" <dr************@gmail.com> wrote
1. I am not very comfortable in VBA for access.
Is there a way to circumvent using VBA and still
manage full functionality.
No, VBA can provide functionality that is not possible with macros, as Allen
pointed out.
A significant problem with not using VBA is that it is the only way to
include error handling in your database application.
But, as Panzerlied7 said, it is possible to create some very useful
applications without much code. I have a colleague who created an
application that handled ordering, tracking, and delivery of foodstuffs and
supplies for the food service division of a major metropolitan school
district for about ten years. He said the only VBA code in that application
was the code generated by the Access wizards.
2. How many maximum records access table can store?
The maximum total size of an Access (Jet database engine) database is 2GB.
You can attach tables in a separate database, so the maximum size in bytes
(not records) of an Access database is 2GB less a modest amount of space
that Access has to use for control structures, etc..
Larry Linson
Microsoft Access MVP