Results 1 to 10 of 10
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    Hi Jan Karel,

    Looks promising!

    I found one serious problem: AutomationSecurity is not available in Access 2002 (XP). According to How to implement the Application.AutomationSecurity property in Office XP, "The Application object of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint supports this property."

    When I commented out the lines involvomg AutomationSecurity, the backup ran correctly.

    Other remarks:
    - In the caption of lblBackupInterval in frmSettings: inteval > interval
    - The function ExportThisOne isn't used, and it prevents compilation since msBackupFile is not defined.
    - Browse buttons would be nice for the three text boxes in frmSettings, to help prevent typing errors. (There is currently no check that the paths or filenames exist)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    Thanks Hans!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    Is there a way to prevent Access from compiling pieces of code, or do I need to have two versions, one for 2000 and for XP (pre-sp2) and one for XP sp2 and later?
    In Excel, subs which are not called do not compile with the default compiler settings, which eases writing code for multiple versions: you put the version specific code in a function or sub and only call that code for that version(s). Access does not seem to work that way.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    Clever! Works OK now.

    If you'll allow me a few more remarks about frmSettings:
    - I'd replace the source path and source filename boxes by a single box for path+filename, and a browse button that lets the user select path+filename (you'd have to add code for the file dialog API function since Application.FileDialog doesn't exist in Office 2000; see <post:=304,810>post 304,810</post:>).
    - I'd use singular instead of plural in the captions of the labels (e.g. "Path to target file" instead of "Path to target files"). I initially expected to be able to enter multiple entries in one box.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    Thanks, this is more user-friendly.

    A useful tool! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database automatic backup tool (2000, XP, 2003)

    Hi all,

    In <post#=745,488>post 745,488</post#> I asked what the best way is to backup an Access mdb which is in use.

    I have devised a tool which does a timed export of all tables of all Access MDB's you set up in a settings table.

    I'd like you to have a look and give me any suggestions or comments here.

    Enjoy...

    ##### EDIT 2008-12-18 ####
    I've created a web page for this tool:
    http://www.jkp-ads.com/accessdownloads.asp
    #### END EDIT ####
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    I founda workaround by using CallByName, which was introduced with Access 2000.
    So the latest version should work for all versions as from 2000.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    Good suggestions. As it happens I already made some changes to the file selecting part, see attached.

    I also included the possibility to enter a period of time in which to suspend the backups, e.g. when you only want it to happen during the day.

    ### EDIT: removed attachment, see my website for most recent version ###
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    impressive
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database automatic backup tool (2000, XP, 2003)

    Thanks!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •