Results 1 to 2 of 2
  1. #1
    TenOc is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    94

    Button to backup database -- Does it work always??

    Access 2019

    I have a button on a form that I want to backup the complete database. I used a macro see photo below


    Click image for larger version. 

Name:	Backup Button.png 
Views:	19 
Size:	23.2 KB 
ID:	37899

    Click image for larger version. 

Name:	Backup Button 2.png 
Views:	18 
Size:	10.7 KB 
ID:	37900



    Click image for larger version. 

Name:	Backup Button 3.png 
Views:	18 
Size:	18.4 KB 
ID:	37901


    It appears to work. However, I have read when searching on how to backup a open database I have found LOTS of code to do what this simple micro appears to do.



    It has also automatically created a table tblBackupDetails.

    I have searched for information on the function BackupOnOpen() and the table without any success.

    Before I release the database to the user is there any reason that I should be worried that the backup will not work????

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Backup DataBase using a command button
    By Peter Simpson in forum Access
    Replies: 5
    Last Post: 11-17-2017, 08:55 AM
  2. Backup Database
    By DPS in forum Access
    Replies: 5
    Last Post: 10-30-2015, 08:20 AM
  3. Backup database
    By mathhero in forum Access
    Replies: 2
    Last Post: 10-30-2015, 04:49 AM
  4. Button to backup database ???
    By TenOc in forum Programming
    Replies: 2
    Last Post: 02-15-2015, 08:33 PM
  5. access database backup...
    By alex_raju in forum Access
    Replies: 5
    Last Post: 07-17-2011, 09:00 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums