Front End Access and Back End as SQL Server

Dear Friends,

We have MS Access database with Forms and Reports, which was started 10 years ago by users and now the data is growing very rapidly.

Did anyone tried by having MS Access as front end and SQL Server 2000/2005 as backend with minimum modifications to the forms and reports in MS Access?

Please let me know, your ideas and if there are any links in the web or in Microsoft please provide here.

Thanks in advance,

Wrong forum for this - you might try the Database Engine forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1)

or the Getting Started forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1)