Does Access XP and 2003 support stored procedures? I read somewhere that it did but now I can't find the article.

Yes and no. An Access Project supports stored procedures from its associated SQL Server database, but an Access Database does not.

Stu9820,
  It depends on your point of view. For instance, an Access database can use ADO to open a recordset via a stored proc in SQL Server. The ADO recordset can then be assigned to the form's recordset and tada, the form is bound to the recordset in SQL Server and is fully updatable. I do this all the time. I currently working on an application where there are no tables in the front end. Everything comes from SQL Server via recordsets...very cool and very fast.

Hope this helps,
Mike

Look into MSDE. This is a free version of SQL Server which has the full functionallity of SQL Server with a limit of 2GB for a database and 5 concurrent users (but this depends on how you develop the front end).

Do a searh on the forum for more info.





Sal