Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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



Group: General Forum Members
Last Login: Yesterday @ 3:50 PM
Points: 2,267, Visits: 3,112
Can you please send me the steps to create SPs in MS Access 2010?

Post #1492440
Posted Friday, September 6, 2013 7:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 237, Visits: 1,580
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.

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