Hi all,
I'm currently running a database with around 30 users, four or five of whom are capable of creating their own queries.
Due to the number of bespoke requests I get for one off queries (and as Im not actually IT, i've just inherited the running of this), I dont have time to create new queries everytime information is needed, I'd rather allw those who can, do.
Occasionally though I have to issue a new version of the front end (the DB is split) as some updates are inevitable.
When I issue a new front end, I have to round up any new code written by others, and include this in the new version, to save their work being over-written. ideally I'd like to be able to save all the custom SQL in one place.
In my previous employment we had a database within which custom SQL was saved to a specific table (the format was fairly simple: ID,name, SQL) with a memo field to hold any code written for a bespoke query.
There was then within that database a form where you could select a custom query from a drop down list, push a button, and the SQL in the table would run.
Any ideas how this was done so I can re-create this?
P.S. I sort of burnt my bridges when I left the last place, so I can't really phone up and ask how they did it.
All help appreciated.