Is there a way to access (view) the "Destination DB" property of the QueryDef object through VBA code?
I relinked some tables to a backend database that's now in a different location. My action queries that update these tables still reference the old location. I'd like to scan all the queries via VBA to make sure I've got the Destination DB property fixed (rather than stepping through each of them in Design Mode and looking at the Property list). Or is there another way to efficiently update this property?