<

Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Executing a SQL Server Stored Procedure from Within Access

Posted on
19,537 Points
10,737 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.

Get your Conversational Ransomware Defense e‑book
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

28
Comment
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 11

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month