MS Access connect to MS SQL Server 2000

anybody have experience connecting Access (front end) to SQL Server 2000 (back end)? specifically i’m interested in using an Access form to pass parameters to a stored procedure which will run on the server and pull the results back into Access.