SA: Better way to use SQL Server stored procedures and functions in VBA

While it is possible to simply concatenate SQL strings in VBA and executing them, maintaining it can become onerous in a large application. Find out how we can write a Object-Relational Mapper generator to create VBA code that provides strong-typing and compiler-validated code for calling stored procedures or functions from VBA, making it easier to handle changes in the code.

Please be advised that the presenter, Ben Clothier (multiple Access MVP), is deaf. What you will hear is the voice of the interpreter. Thank you for your understanding.

✓ Join our online Access User Groups with free membership. Monthly webinars on the latest topics: MS Access, MS Access with SQL Server, etc.

► Facebook ◄

► Twitter ◄

[tetsballer]

That error form is pretty nice! Better than ctrl + break and resume next after the error is caught :)