Converting to MS Sql back end

Hi, we have a bunch of applications that were first developed in access
version 97. Most are now converted to version 2003. However, the code in
these applications have generally not been changed to reflect the 4.0 db
engine. For a number of reasons we would like to move from having ms access
as the back end file type to ms sql.

I would like pointers/suggestions/recommendations for methodology to migrate
to ms sql. In particular I would like to optimise each application to run on
ms sql. It is the aim to optimise each application that I would like the most
assistance.

Any ideas and suggestions appreciated :-)

Many thanks
Jonathan

Thanks for the recommendation. I will follow your advice.

Should anyone else have ideas, please let me know

Many thanks
Jonathan

"Granny Spitz via AccessMonster.com" wrote:

Jonathan wrote:
I would like pointers/suggestions/recommendations for methodology to migrate
to ms sql. In particular I would like to optimise each application to run on
ms sql.

Read Mary Chipman's and Andy Baron's book, "Microsoft Access Developer's
Guide to SQL Server." It's a five-star book at Amazon.com for a very good
reason.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200610/1