Thanks Pardede -- I've been in the ADO/SQL server mindset for a while and have pretty much abandoned DAO..... I suppose once I relate DAOs WORKSPACE object with ADOs CONNECTION object, the situation you described makes sense. I'll keep that in mind for the future, thanks!

Tom