J
Jone
Hi ! HAPPY NEW YEAR!!!,
What code do I write when I want the back up database option to come up
What code do I write when I want the back up database option to come up
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stuart McCall
Jone said:Hi ! HAPPY NEW YEAR!!!,
What code do I write when I want the back up database option to come up
DoCmd.RunCommand acCmdBackup
J
Jone
D
Douglas J. Steele
"not working" doesn't really give us much to go by.
Do you get an error message? If so, what's the error? If you don't get an
error message, what happens when you run the code? For that matter, how are
you running the code? (i.e.: are you certainly that it's running?)
Do you get an error message? If so, what's the error? If you don't get an
error message, what happens when you run the code? For that matter, how are
you running the code? (i.e.: are you certainly that it's running?)
J
Jone
It says "The command or action "Backup" is not available now"
D
Douglas J. Steele
How are you trying to run the code?
S
Stuart McCall
Hi Doug
I've been playing with this and now I'm not sure that this is possible,
because the first thing the backup routine attempts is a compact. Since you
can't compact a database with a running macro or code, the runcommand is
just not going to do it. Makes you wonder why MS included it at all.
(the reason I posted it was just that I remembered seeing it in the acCmd
list)
I've been playing with this and now I'm not sure that this is possible,
because the first thing the backup routine attempts is a compact. Since you
can't compact a database with a running macro or code, the runcommand is
just not going to do it. Makes you wonder why MS included it at all.
(the reason I posted it was just that I remembered seeing it in the acCmd
list)
D
Douglas J. Steele
You could be right.
I've never tried using the command. Since all of my databases are split, and
since I can't see any reason to backup the front-end, I've never needed to
worry about it. It's a simple matter to use FileCopy to make a backup of the
back-end when there's no open connections to it.
I've never tried using the command. Since all of my databases are split, and
since I can't see any reason to backup the front-end, I've never needed to
worry about it. It's a simple matter to use FileCopy to make a backup of the
back-end when there's no open connections to it.
J
Jone
How do I use FileCopy
Douglas J. Steele said:You could be right.
I've never tried using the command. Since all of my databases are split, and
since I can't see any reason to backup the front-end, I've never needed to
worry about it. It's a simple matter to use FileCopy to make a backup of the
back-end when there's no open connections to it.
D
Douglas J. Steele
FileCopy source, destination
For example, to take a file C:\Folder\File.mdb and create a copy that has
the current date in the file name (C:\Folder\File2008-01-03.mdb), you'd use
FileCopy "C:\Folder\File.mdb", "C:\Folder\File" & Format(Date(),
"yyyy-mm-dd") & ".mdb"
For example, to take a file C:\Folder\File.mdb and create a copy that has
the current date in the file name (C:\Folder\File2008-01-03.mdb), you'd use
FileCopy "C:\Folder\File.mdb", "C:\Folder\File" & Format(Date(),
"yyyy-mm-dd") & ".mdb"
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.