I had always been told Access cannot do stored procs

[Matt_T_hat]

I had always been told Access cannot do stored procedures however this microsoft article says otherwise.

http://msdn.microsoft.com/office/und...l/acadvsql.asp

How about that then!

[mendhak]

And from what I've been told and understood lately, they exist in Access but aren't as powerful as those in SQL Server. There are some limitations which I don't remember at the moment.

[mendhak]

Ah yes, here you go:

There are some limitations you may encounter here, especially if you're used to the power of SQL Server.

* Output parameters cannot be used.
* Don't use the @ character. The @ character is often used in Transact SQL (SQL Server), where it represents a local variable. Access doesn't always convert this character and will sometimes leave it out. This can cause esoteric bugs which can lead to premature hair loss.
* Temporary tables are not available in Access.
* I suspect many of the options available in Transact SQL are not available in Access as it's not Transact SQL compatible.

[aidan]

That's very useful to know. Thanks