Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Posts
    1

    Question Unanswered: Using mdw files - local copy

    We use mdw files for most of our databases. (dbs are split with front-end/back-ends) We've had a few issues with a specific pc/user "locking" the mdw file so other users can't use the db. The network administrator has to resolve the issue on the server.

    He suggested putting copies of the mdw on the local machines, since the mdw file doesn't change very often.

    Is this a good or bad workaround? What are the issues with doing this?

    Thanks for your comments!
    Lynnette

  2. #2
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama
    Posts
    12
    Yes .... that's the best way to handle it. Place a copy of the .mdw on each local machine.

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama

  3. #3
    Join Date
    Jan 2002
    Location
    UK
    Posts
    67

    Question

    but wont this create problems when the users change their passwords????

  4. #4
    Join Date
    Jan 2002
    Location
    At the Edge of America!
    Posts
    55
    I am really not sure how a user could lock a MDW file. You should put the mdw file in a hidden folder on the network. Map the location using the UNC address. I have the same set up here we have about 23 users and Have never had that problem.
    Just My thoughts!

Posting Permissions

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