Hi Dave,
Your absolutly right that the syntax is likely to be incompatible, but you
can get the select statement from the DB some how, I down loaded ADO Query
Tool from this guys site todo on the fly SQL with the Access DB and it
manages to get the SQL statements from views....
http://gpoulose.home.att.net/
I'll keep trawling until I find something more useful, that is if mu ISP
doesn't give up the ghost again.....
Regards, Brett
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com