<

Watch Executing a SQL Server Stored Procedure from Within Access

Posted on
21,464 Points
12,665 Views
28 Endorsements
Last Modified:
Experience Level: Beginner
5:16
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.

Video Steps

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.

28
Author:TechMommy
6 Comments

Expert Comment

by:Eduardo Mesa
Why the video can't view full screen?
0

Expert Comment

by:Leonidas Hänz
the code is single, practical and it useless for me ,but i guess some words while i writting dummy test.
0

Expert Comment

by:dougfosterNYC
OMG, Alison Balter.  I took a couple VB courses of hers in the early 1990s.  She is awesome, a really great teacher.  I still have her Access 97 book which is my absolute favorite tech book ever, and very, very dog eared.  

I'm now doing hard core SQL Server and Excel/Access VBA, and I can thank her for really getting me going in this arena so many years ago....
1
LVL 12

Author Comment

by:TechMommy
Hi Doug,

Thank you for your kind words. I really appreciate you taking the time to place your comments. I am glad that I had a positive impact on your programming career. It is awesome that you are doing such wonderful things with your career!

Best to you!

Alison
0

Expert Comment

by:Brogrim
Not just Doug , there is 1000's of us who broke the back of programming with your books. as the saying goes "Give a man a fish, you feed him for a day, teach him how to fish an you feed him for life".

Thanks Alison

Alan
President of your Irish Fan Club
0

Expert Comment

by:SantiASC
Hello,

The connection works perfectly, thank you. How can I display this data in a query or table?

Thank you.
0
A small Access Application that shows the handling of .jpg images to assign them to popular Microsoft Access Controls while stored in the Application itself in their original format.
A description of how I fixed an Azure AD Connect password synchronization error.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month