• I have never seen this problem unless it was a rights issue.  If you are using the same ODBC connection, then that is not the case.  Not many people will see your question in this particular forum.  If you haven't already, post the question in the Access forum.  I think you'll be forgiven for cross-posting in this case.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor