Act!2009.  Changed drive letter for db and cannot access the database

Posted on 2012-08-21
Last Modified: 2012-08-22
IT changed the drive letter for the network drive where the ACT database lives.  Using ACTDIAGS I am able to see the database and it's path to the old drive.  Googling this problem  came up with detaching and reattaching the database.  But the 'Detach' option is grayed out.
Any suggestions?
Question by:gbnorton
    LVL 13

    Expert Comment

    by:Norm Dickinson
    If you have permissions on the network you can always map another drive letter to the folder you need. Just locate the place your database is under Computer or Network Neighborhood and right click on the folder, then choose Map Network Drive and assign it the old drive letter. Or contact the help desk and let them know they crashed the database - they will fix it for you.

    Author Comment

    The drive letter change occurred on the file server.  It was like this E:\Act\db.  Now it is F:\Act\Db.  "Act" is the shared folder.  On the client computers it looks the same.  But Sql Server and Act are still looking for the database on drive E:.  I can re-letter the drive from F back to E, but that will break the share and disrupt many many users.  So I am looking for a way to have Sql Server and Act look to the new location.
    LVL 13

    Accepted Solution

    Create a folder with the old drive letter (or create a new folder on the drive that is now using that letter) and copy the database there long enough to get it to recognize, then break the connection and reconnect it to the new location.
    LVL 30

    Expert Comment

    by:Mike Lazarus
    On the server:
    1. Delete the PAD file
    2. Open ACT!
    3. File | Open
    4. Change File Type to ADF
    5. Select the database

    This should open and verify the database and rebuild the PAD file so that it correctly points at the new location

    Author Closing Comment

    Worked.  Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Suggested Solutions

    Title # Comments Views Activity
    Wordpress data download 4 58
    Change variables in SQL table 6 52
    Compare and update data between two databases 6 31
    MarkLogic 1 24
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
    The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
    Introduction to GIMP:  GNU Image Manipulation Program. It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now