I have an Access front end with linked tables and views to a SQL backend.
I'm trying to narrow the record set but "filtering" it with views. Records have an "Active" or "Inactive" (or "Deleted") status and I have a form that gives me the option to view view Active, Inactive, or Deleted and upon selection, changes the form's record source to the appropriate SQL view.
If I open the views in SQL Management Studio, I have data.
If I open them in Access, they are empty.
I've refreshed the table links.
What am I missing?
(Access 2010 and 2013)