Thanks arnelgp that's closer to what I am looking for.
Isladogs (and everyone),
I don't really want a "back-up". What I am trying to get around is this:
Every time I create a new accdb file (sometimes several times a day), there's a myriad of set-up options I always change, in order to make the MS Access settings to my liking.
In truth, I am requesting this code, simply because I've gotten tired of doing this, each and every time I create a new MS Access Db file.
I slice and dice data all the time and use MS Access to do this and (for example) I can't really use MS Access in the default Tab format (because it doesn't allow me to see two or three datasets matched up against each other at one time (i.e. I can't eyeball deltas, in tab format, which I need to do in my job)
So to set a new accdb file, the way I like/need it... I have to go into File>>Options>>Current Database... click overlapping windows (along with a few other changes) then click OK... I am then warned that these changes will not take, until the database has been closed and reopened... instead I go back to File and choose compact & repair...
I have to do this EVERY TIME I create a new MS Access file... it gets tedious. This isn't a big deal because I have done it about 7.84M times... but I was thinking... since we use code to deal with repetitive actions like this, I am looking for a way to bypass these repetitive actions. So yesterday I created a brand new template database file, where the settings are exactly the way I want.
And...Yes, I could just go to the template (every time I need a new MS Access file) and copy it and then paste it somewhere else and then change the name yada yada... but I'd much rather have a shortcut to this template file, accessible on my tool bar, that I can click any time I need a new file... and when the template file opens, it simply saves this template file elsewhere (i.e. to a place on my hard drive, I've direct and with a new name that I give it) "save as".
So far arnelgp has given me something to chew on (thanks so much for creating this for me arnelgp, very much appreciated)...
If anyone can direct me to a link that would help me attain the above, I'd be extremely grateful.
Isladogs: Option #2 and #3 might be doable... do you have any code or links you might provide? I'm at a loss at the moment as to how to go about this. Also I work on a US-DoD machine, so I am not sure it would even allow me to use VB Script to copy the file... but if they do, perhaps that's really the avenue I need to pursue.
Thanks to everyone for the ideas!
Respectfully,
Gary