4 Replies Latest reply: May 15, 2014 9:57 AM by Bruce _ RSS

    Opening Union Querys with Monarch from Access

    Bruce _

      I am using Monarch 2002 to hook into an Access database with no problems. However I set up a union query (using Access), and now Monarch cannot see this new query. All the other querys and tables are visable and usuable with Monarch.

       

      If I then use Access to make another SELECT query based on the union query, Monarch can see the select query.

       

      My work-around seems OK, but I would like to use the union query directly.

       

      Any thoughts on what I should check? I am using the local or network option, and not OBDC or OLEDB.

       

      Thanks