Results 1 to 3 of 3

Thread: creating MDE

  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: creating MDE

    why is it that sometimes when I compact/repair or try and create an MDE it comes up with an error saying that the file is in use....

    but i am the only person connected to the program at the time.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by DackJaniels
    why is it that sometimes when I compact/repair or try and create an MDE it comes up with an error saying that the file is in use....

    but i am the only person connected to the program at the time.
    Check your lockfile ... If after you exit from the DB in question, the .LDB file remains then you had a previous untimely exit. Try deleting the lockfile.
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Compact and repair problem

    I only had this problem when there was something wrong in the code (i.e. a period instead of an !) or something else like a recordset not closing properly.

Posting Permissions

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