Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access is a SQL Server stored procedure. After writing the necessary code, you can programmatically execute even a parameterized SQL Server stored procedure.
1. The video first shows the viewer the SQL Server stored procedure that the code will execute.
2. The video then takes a step-by-step approach to the VBA code necessary to execute the stored procedure.
3. Finally, the video demonstrates how to pass parameters from a VBA subroutine to a SQL Server stored procedure.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…