Results 1 to 2 of 2

Thread: Compact

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 2002
    Posts
    126

    Compact

    Hi i was wondering if i can do this in VB i have an access database called SPS.Mdb in c:\SPS\SPS.mdb what i want to do is when a user presses command1 i want vb to copy and compact and rename it with todays date (e.g 12December2002) the database then place the database in a folder called SPSBackup in c:\SPS\BackUp.

    Can you help

    Thanks
    beginner

  2. #2
    Frenzied Member
    Join Date
    Jul 2002
    Posts
    1,370
    This code from www.mvps.org Dev Ashish's site will compact Access 97 - see the site for more info
    Attached Files Attached Files

Posting Permissions

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



Click Here to Expand Forum to Full Width