Doc Man...
The point is this: Every time I open a new MS Access accdb... I have to open MS Access (which on my Govt computer, takes time) and create the accdb file... then run through these steps: goto File>>Options>>Current database>> change the settings I prefer>>click OK>>click OK again, when the Message pops up that tells me settings won't be applied, until you close the Db and reopen>>goto repair & compact and click that...then start whatever process I needed the database for.
This process contains way more steps, than I would like it to take... and that I have been taking, for years now...
That said, I am looking for a way to rapidly copy a template Db... So making a template in Access does work, but I still have to open access (which, like I said... is slow). So, I am looking for more speed.
I don't want to do all that every time, so my thought was that I would make a "template" accdb file... put a shortcut to it on my windows tool bar so whenever I need a database (with all my settings) I simply click the shortcut and BAM! a I am prompted to save the file with all my custom settings (giving it whatever name I like).
Then... if i need another new accdb file (for some unrelated dataset)... I simply click that shortcut again and BAM! I am prompted again to save the file again, but with some other name, rinse, repeat, over & over...
Anyway, that's what I am looking for. Underlying business reason: It saves me time, each and every time I have to create a new Db (which I do, often).
That said, I don't know how to write the VBA (or VB Script) to make this work, which is why I am asking all you Big Brain Folks to help me with that, if you can.
The one set of code I got (I think from Pat, I apologize I should not have assumed gender) was close to what I was asking, but not quite and I figured I would make attempts to fiddle with it, at a later date, and perhaps figure it out... BUT... if you guys know of an answer, I'd love to get it.
So, Doc Man does what I wrote (above) make sense? If not I am happy to try to answer whatever I can, I guess I am not so great at explaining stuff.
Isladog...
Yes, you gave me high level options when I was specifically asking for help with code. But yes I did read and try #2... but I couldn't get that to work:
1. Open the database as read only using the /ro switch in a shortcut.
2. Open the database using a vb script which includes making a file copy before the app is opened
3. Create a backup routine and save it as a function. Then run that function at startup using an autoexec macro or from the load event of your startup form.
Going in order:
1. Is too clunky, not what i'm looking for. I want to quickly open the Db into:"Save As".
2. I actually attempted the VB script, but I couldn't get it to work. I'm not adept with that... and I googled it, but I couldn't find the code that would let me do the aforementioned things, I listed above (i.e. Prompt for a "Save AS"). Like I said, I was asking for help with code... I'll admit I don't know how to write this code.
3. Is MUCH closer to what I want... But honestly, I felt: that's what I was asking for and you were suggesting that I do this...I don't know how to do this, but if you do, I'd be grateful for your help, or for any links that might help me figure this out.
In the end, the template thing does work, and is faster, but it's still slow for me because I have to open Access each time, but it's way better than nothing!
So, it wasn't exactly what I was looking for, but it did do something close and so I figured that's what I was going to get. As such, I was trying to be grateful and gracious by saying it worked for me and by thanking EVERYONE for their input.
It kind felt like I was asking for a kayak and I ended up getting a canoe...So, I was thankful for getting that... at least it something and it floats. Still, I wasn't asking for the canoe, exactly...
Isladog I apologize for getting off on the wrong foot, I do appreciate yours and everyone's help and input... I know you guys are doing this to help people, so thank you!
If any of you have a closer solution (as to what I explained, above) I would very much appreciate the help. If I somehow rubbed folks the wrong way, and there's no chance of further help... then I am truly sorry and the template solution will have to work for me
In any event I thank everyone for their time and attention and if I do end up figuring out how to code this all by myself, I'll certainly post it here.
Thanks again to everyone!
Sincerely,
Gary