Dan Waters
dwaters at usinternet.com
Thu Jan 3 21:02:30 CST 2008
Last month, MS published a 52 page white paper on how to do this here: http://www.microsoft.com/sql/techinfo/whitepapers/MigrAccessSQL2005.mspx About half of this paper is a list of how to rewrite Access query syntax into SQL Server 2005 syntax, and it lists which ones will be converted by SSMA and which ones wont. This will help me hope it helps someone else! Dan Oh - and the authors are all Russian - Shamil protégés no doubt!