Re: VB in Access

"MontainDoctor" <dr.rakeshverma@xxxxxxxxx> 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



.

Relevant Pages

  • Re: I need some expert advice on database design
    ... What version of Access did the consultant say he worked with last? ... Using Access you can create a workable database without using or knowing ... However, depending on your organizations needs, coding VBA is suitable ... do more than just creating some macros and converting them to code. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Roll-up tasks by person?
    ... Ali wrote: ... of the box functionality, or macros, or even with plugins): ... functionality is to use one of Project's advanced features, namely VBA. ...
    (microsoft.public.project)
  • Re: Error message "Error accessing file" in VBA Applications
    ... the "permanent solution Microsoft is offering" is to ... > the VBA procedures. ... I created in Access2000 e.g. a database for the ... >>The VBA macros I access through Event Procedures like On Click or On Enter, ...
    (microsoft.public.access.macros)
  • Re: Merging content from access
    ... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
    (microsoft.public.word.docmanagement)
  • RE: Error message "Error accessing file" in VBA Applications
    ... the VBA procedures. ... I created in Access2000 e.g. a database for the ... > The VBA macros I access through Event Procedures like On Click or On Enter, ... > My only way to overcome the fault is to develop the form again from the ...
    (microsoft.public.access.macros)