Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating Procedures in MS Access Expand / Collapse
Author
Message
Posted Friday, September 6, 2013 3:36 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 10:50 PM
Points: 858, Visits: 1,389
Can you please send me the steps to create SPs in MS Access 2010?

Thanks.
Post #1492440
Posted Friday, September 6, 2013 7:51 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 148, Visits: 542
First of all you should be working with an ADP (Addess Data Project), and not an ACCDB or MDB file. Second, you should know that effective with Access 2013, the ADP format is no longer supported, so you are headed down a dead-end.

Given that caution, you simply choose the Create ribbon, and choose the Query Wizard button, and then choose either Design Stored Procedure for simple sprocs, or Create Text Stored Procedure, where you write the T-SQL a line at a time. (Note that you can also create several other SQL Server object types in the New Query dialog.)

On the other hand, should you decide that's not a good choice, using the .MDB format or .ACCDB format, you can link to a view, and have it be treated like a table within Access, and you can also use pass-through queries to execute sprocs which return records. Both of those subjects require more explanation than can reasonably fit in a formum post however.


Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Post #1492465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse