I am wondering what you all think about designing front end applications via Access and whether one should use Access objects or simply hard-code everything via VBA in forms.
Essentially, what I'm asking is whether one of the two following routes have a preference, and why. Route 1 would be creating your Access FE application with linked tables, queries, modules, macros, etc... essentially using all the built in object features in access.
Or for route 2, simply creating your forms in access but doing all queries, linked tables, etc. via connection strings. Essentially, making the entire Application VBA based.
Are there advantages to either route? Could you please elaborate on some short-comings for either?
Thanks!
Essentially, what I'm asking is whether one of the two following routes have a preference, and why. Route 1 would be creating your Access FE application with linked tables, queries, modules, macros, etc... essentially using all the built in object features in access.
Or for route 2, simply creating your forms in access but doing all queries, linked tables, etc. via connection strings. Essentially, making the entire Application VBA based.
Are there advantages to either route? Could you please elaborate on some short-comings for either?
Thanks!