Alan, that was similar to what I tried but I couldn't get my code to work reliably. One major difference is that I was trying not to include the source program code.
I was storing the object code in seperate database which had one record for each procedure, then at runtime I would copy this objcode into the MyDB database and try to run it. Problem was it looked like some sort of caching was getting in the way. Even FLocking before copying in the object code didn't help. When I tried to run the procedure it would not be found, at least not until a few seconds later. Opening the Database Exclusive did help a bit but not totally reliable, also that meant closing the database every time to write new code in which was way too slow.
> It probably needs a user to break it.
So let me be a user then :), no can't break it works perfectly.
Although not exactly what I was looking for it is certainly a very interesting utility.
Many thanks,
Nick