It's quite possible to use Access to call a SQL Server procedure; you'll need to have a link to your SQL Server established in the Access file first, however. If you have one (and if not, I can provide some assistance in doing so), create a Pass-Through query; it's one of the options grouped in with the rest of the types in the Query section.

Once you make the pass-through query, just enter the call to the procedure as you would in SQL Server. So, EXEC (Database).(Schema).(Procname), and put a call to the query where it's needed, either in the VBA coding for a button or form event, and that should handle it.

My memory for the process is a bit fuzzy, since I haven't had to do this in quite awhile, so if I've slipped up somewhere, let me know and I'll try to correct things.