A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Back up Database Button



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2004, 12:06 AM
Clockwork
external usenet poster
 
Posts: n/a
Default Back up Database Button

I'm trying to make a backup database button on my switchboard. Is this possible? If so, then what's the Back up Database run code command? Any help will be appreciated.
  #2  
Old April 25th, 2004, 07:57 PM
Ed Robichaud
external usenet poster
 
Posts: n/a
Default Back up Database Button

What you describe is not possible (to my knowledge). An Access MDB must be
closed before a copy/backup operation. DBMaint is a good third-party tool
for MDB compact and backup.
-Ed

"Clockwork" wrote in message
...
I'm trying to make a backup database button on my switchboard. Is this

possible? If so, then what's the Back up Database run code command? Any help
will be appreciated.


  #3  
Old April 26th, 2004, 07:51 AM
Clockwork
external usenet poster
 
Posts: n/a
Default Back up Database Button

Thanks. Although I've already read about how it has to be closed before it can be backed up. But When you click on the Back up Database option under Database Utilities It closes the MDB you have open, backs it up, and then reopens the file. That's what I failed to mention. Maybe I misunderstood what I've read?

  #4  
Old April 26th, 2004, 06:56 PM
Ed Robichaud
external usenet poster
 
Posts: n/a
Default Back up Database Button

What you state is correct. Remember though, you're trying to use code
contained within an mdb to: close itself, then reopen - a desirable, but
impossible task.
-Ed

"Clockwork" wrote in message
...
Thanks. Although I've already read about how it has to be closed before it

can be backed up. But When you click on the Back up Database option under
Database Utilities It closes the MDB you have open, backs it up, and then
reopens the file. That's what I failed to mention. Maybe I misunderstood
what I've read?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.