Why would I get different results in a query after I split my DB?
After a split I don't list tblParts in my query only tblPartsB* tables.
I still have to check for other problems, but most seems to work fine.
Thanks!
Code:SELECT MSysObjects.Name, DCount("*","[" & [Name] & "]") AS RecCountFROM MSysObjects WHERE (((MSysObjects.Name) Like "tblPartsB*") or (MSysObjects.Name) Like "tblParts" AND ((MSysObjects.type)=1) AND ((MSysObjects.Flags)=0)) ORDER BY MSysObjects.Name;