I am an Access-user since Access2.0, and since then developped over 100 different applications.
The "weak points" of Access arised with my second or third application: copy/paste, copy paste, ad infinitum.
Since then I started with the generalization of code. This opened the door the (partly) automatic building of applications.
A bottleneck in the further process was the very static behaviour of forms.
Today I use only two form templates (one continuous and one unbound) to generate any "form" ad hoc to make the connection between the user and the data. This has resulted in a fast application development tool: definition of controls in metadata tables in the FE, and shared code in a linked library database. Extension and maintenance of 100+ applications is no problem anymore. And any new application contains already a rough 95% of its future functionality.
The "weak points" of Access arised with my second or third application: copy/paste, copy paste, ad infinitum.
Since then I started with the generalization of code. This opened the door the (partly) automatic building of applications.
A bottleneck in the further process was the very static behaviour of forms.
Today I use only two form templates (one continuous and one unbound) to generate any "form" ad hoc to make the connection between the user and the data. This has resulted in a fast application development tool: definition of controls in metadata tables in the FE, and shared code in a linked library database. Extension and maintenance of 100+ applications is no problem anymore. And any new application contains already a rough 95% of its future functionality.