The attached application is made up of 4 forms which can be imported into any access database and should work without any further set up required.

This application is intended to allow your users to create their own simple queries in a safe and controlled environment. You should never give your users direct access to your data, so this is intended as a barrier between the users and your precious data!

I appreciate there are a number of improvements to be made, this was simply constructed as a proof of concept and after a recent thread I have decided to share what I have got so far.

To use the application, simply run the sqlbuild form and it picks up the tables in your database, along with their respective fields, etc. The rest should hopefully be pretty easy to work out!

If you come across any bugs, problems, have any questions, comments or criticism - please feel free to contact me via these forums!

Please note that this application is still in development and as such bugs will occur!

Finally, enjoy!

-George