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