I need to use SQL Server database View as Source for Access form (read only). I read, that unindexed Views Access can only read, so I created a read-only datasource - but it displays only tables (like the read-write one too)! How can I make Views available too?
The query syntax is too complex to port it directly into Access, and I'm afraid it will be too slow when ported using interim saved queries.
I have several SQL databases linked to Access project, and I searched the view in wrong DB