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! :eek2:
Printable View
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! :eek2:
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.
Ah yes, here you go:
Quote:
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.
That's very useful to know. Thanks