Question Robert Bee · Feb 13, 2019 Intersystems Cache and MS Access Passthrough Edit:May have found the issue but not the solution."SELECT * FROM wmhISTORYdETAIL" runs as a passthrough without asking for the DNS.but'SELECT Count([wmhISTORYdETAIL].[HistHMNumber] AS CountOfHistHMNumber FROM [wmhISTORYdETAIL] WHERE ((([wmhISTORYdETAIL].[HistMovType])='Receipt') AND (([wmhISTORYdETAIL].[HistMovDate])>=Date()-1) AND (([wmhISTORYdETAIL].[HistMovDate])<Date()));'asks for the DNS but both are linked to a table that has the password saved.Any Ideas please?RobHi #.NET #Databases #Object Data Model #Caché 0 1 0 334