Gibbo,

Instead of answer I suggest that You try it out and study the outcome. If You got any questions You're most welcome

How serious are You when it comes to ADO / SQL? There exist some good books but they are usually expensive. Except for that they target different DB - platforms (SQL Server, Oracle, DB2 etc) and Access is not usually covered so well.

BTW, I sent You a PM the other day about the ADO helpfile which I believe is the best resource available unless You want buy books.

Kind regards,
Dennis