No, but I have now downloaded it and tried my routine.
First of all you do not appear to have a BE if you put the code in the BE, then it becomes a FE, as far as i coded it at least. Putting BE in the DB name does not make it a BE?, as far as I am aware.
My code is meant to run from the FE, not the BE.
It also is for my setup. I only offered it as something to start with, not a solution that would work in in every situation.
When people offer me code, I fully expect to have to tailor it to my situation, which they are not aware of. I am more than happy to be shown a method to a solution and tweak to my needs.
All I had to do for your DB, was tweak the strBackupPath to have a drive name and it worked from then on using the FE parameter as far as my code was concerned it was a FE as it was being run from the DB it was in.
That at least is my understanding of a FE.?
Personally I have yet to run code from a BE, it has always been there to store tables and not code.
If you see my signature, I am a novice. I create what works for me from what I am offered and am grateful for the advice. I can only offer what works for me and then let the person see if it is useful or not for them.
However you now have a method that appears to work from either DB, so seems a much better solution?
