I'm new to this forum and relativly new to Access. I am using VBA to create a query on the fly. What I want to do in my code is to create this query as read only. I have done this using Macro's but I don't want to use a macro in this case becuase I'm creating my query on the fly based off of user selectable criteria.
Thanks healdem for your reply,
I am trying to open the query in datasheet view but with read only attributes. Using a macro, I can do this to a static query but I am generating this dynamic query based on users inputs and I'm using code to do this. I was wondering if there was code that could set the query that I'm generating to read only in the datasheet view like the macro does. I may have to create a form for this and lock this fields out but I was originally going to do it the way described above.