Should I include my stored queries in my new SQL database?

[steve728]

I'm trying to learn all about converting to Access Front end and SQL Server backend. I typically split my applications into forms, reports, modules and stored queries in one mdb and all the tables in another mdb. I read that tables, queries and database diagrams should be located on the server side and the forms, reports and modules should be stored on the clients side. Do I export all the queries from the application side into the data side before I convert it into a SQL database? Please help me with some advise.

Steve G.

 

[cmmrfrds]

You should be able to run the upsizing wizard against the client mdb which includes the queries.