Results 1 to 2 of 2

Thread: Renaming a database after compacting it

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 1999
    Location
    Canada
    Posts
    2

    Post

    I have a VB front end that uses an Access db.the path of the database is set in the code. After the db is compacted I would like to rename the new db to the original name so that the program can still find it.
    Thanks in Advance.
    Peter

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    Compact it to the users TEMP directory, delete the old database file and copy the new one to the old one's dir with the same name

    Tom

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