Move Access queries to SQL server

[AnnPhil]

I have an Access front end that has all the queries, forms and reports. The tables are linked to SQL server. How do i move the access queries to sql? Is Access Project the only way? When i try to link to a stored procedure in SQL server it doesnt show up in the lists like the tables do. All my forms records source are tied to access queries and i want to change that to sql server stored procedures. I am able to create them in Sql server but do not know how to reference a stored procedure in the Access forms record source.

Any help is appreicated.

 

[tehNellie]

You can't link to a Stored procedure like you can a view.

You can issue a passthrough query to execute your stored procedure on the server. the SQL in your passthrough query would be "exec storedprocname". I tend not to use these but it appears you should be able to call the passthrough query in Access as you would a local one and might possibly be the quickest way to move to stored procedures without having to redevelop your entire application.

You can also use a Command or Connection objects in VBA to execute your Stored procedures but that will require significant redevelopment of your existing application.