Here's the deal. I need to take the value from one Access Database, eg. State, and look it up in another Access Database. How can I setup the SQL Statement to use these parameters?
Have 2 diff DSNs and point each to diff databases.<BR><BR><BR>then get from one using one DSN and then compare with the other db using the other DSN.<BR><BR>