R
rpg
Hi
I have been struggling with this problem for a few days. I have a simple
(unsplit) .mdb file and would like to set up a control within it to back it
up. I first noted that it was possible to copy a db manually in windows
explorer as long as the objects had been updated. So I tried to generate
the VBA code to execute this, but an error message states it can't be backed
up if it is open. So I then tried to use OpenCurrentDatabase and Shell
methods to open a companion db populated with only a simple form to copy the
main db to a backup file. This failed also: the subordinate db stubbornly
refused to open. Perhaps I could revert to an old batch file to perform the
backup operation and call it from access on exiting, but there is no
elegance in this. It seems this should be a common consideration. Isn't
there a better way? It probably could be done with a VB file, but
unfortunately, VBA is enough of a challenge for me at this point.
Thanks, RPG
I have been struggling with this problem for a few days. I have a simple
(unsplit) .mdb file and would like to set up a control within it to back it
up. I first noted that it was possible to copy a db manually in windows
explorer as long as the objects had been updated. So I tried to generate
the VBA code to execute this, but an error message states it can't be backed
up if it is open. So I then tried to use OpenCurrentDatabase and Shell
methods to open a companion db populated with only a simple form to copy the
main db to a backup file. This failed also: the subordinate db stubbornly
refused to open. Perhaps I could revert to an old batch file to perform the
backup operation and call it from access on exiting, but there is no
elegance in this. It seems this should be a common consideration. Isn't
there a better way? It probably could be done with a VB file, but
unfortunately, VBA is enough of a challenge for me at this point.
Thanks, RPG