I meant and do have in code "Set NoCount On".

The Error occurs right at the

Set rst = dbGMS.OpenRecordset(mstrSQL, dbOpenSnapshot,
dbSQLPassThrough) line.

If I add the error code you sent right before that, will it help any in
capturing?

Also, what would be the ADO command string - that may be easiest to
try, since I will have to have a user walk through the error code - not
a great way to troubleshoot;-)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/