Hi Dan,
Sorry for causing additional work to getting the test setup, I will take your advice should I need to post these type of details again....
With regards to your solution, it works perfectly!!! Great thanks for putting the time and effort in to help sort this problem. Much appreciated.
I didn't even know you could connect without a DSN in VBA. I'm basically teaching myself VBA from doing tutorials and experimenting. I'll take a look on the net and see how the DSN-less connection is done. Thanks for the heads up.
Kind Regards
[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]