Stored Procedures & ASP?

Is it possible to reference and use stored procedures with SQL (or even Access) and ASP? Would there be any advantages to this? What about disadvantages?

It seems like you could have a completely modifiable website, running only one .asp document.

Yes, this is possible.
Advantages:
1) You cut down on the possibility of SQL Injection attacks.
2) Stored procedures are compiled, so they execute faster.

Disadvantages:
1) You need to learn how to create them.

I'm not worried about the difficulty - in fact, if I WERE to use them, I'd probably continue to use Access like I am now. So that, in turn, is a whole other problem.

Thanks for the reply.

One more question: If I were to use stored procedures, could I still potentially run into stack issues?

Not sure what you mean by stack issues?

Access doesn't have stored procedures, however you can get similar functionality with queries.

You define a query and call it like a SP, heres some google stuff about it:

http://www.google.se/search?q=%2Bac...F-8&hl=sv&meta=

But, it isn't compiled so the speed is still the same and it is just simple queries and not really like an SP in SQL Server.

If you want to use sp's you should probably look into getting SQL Server.