<

Executing a SQL Server Stored Procedure from Within Access

Posted on
22,361 Points
6 Comments
13,461 Views
29 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:15
TechMommy
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.

29
Author:TechMommy
6 Comments

Comment

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

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

Comment

by:Doug Foster
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

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

Comment

by:SantiASC
Hello,

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

Thank you.
0
Storing passwords in VBA using the Microsoft NG Cryptography (CNG) API
Article by: Gustav
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Handling passwords.
Some database design ideas
Article by: Thomas
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user.  I would like to think this is a "le…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month