I have a rather extensive project involving many reports that were created inside an adp project that was hitting a SQL 2k Server. Due to certain additional parameters that I have to work within, I now have to incorporate linked table functionality on the access side. In order to do this, I have had to switch to an mdb with linked tables. This creates problems with all of my reports as their datasources are coded in t-sql. While I'm fairly comfortable with jet-sql, there are MANY reports and I would prefer to run the datasources through a converter if at all possible.
Are there any utilities existing that will convert fairly simple queries from t-sql to jet sql?