Cannot Open .ADF File in ACT 2006

Posted on 2007-07-31
Last Modified: 2009-05-29
Cannot open an .ADF file after computer crash.  I had a computer go down that was running the ACT database.  I was able to get the information off the HD before reformatting, and installing Windows XP.  I have restored Windows XP and reloaded ACT onto the computer.  I then copied down the backup and tried to open the .ADF file and get a message similar to this:

Device Activation Error: the physical file c:\docsandsettings\whoever\blahblah.alf may be incorrect.

Any ideas on what to do to fix this?  I need to open this DB asap.

Thanks for any help in advance.
Question by:metsfan421
    LVL 30

    Accepted Solution

    It sounds like you didn't copy all of the files.

    This can be caused by a damaged or missing .ALF file associated with your database while the .ADF file associated with your database is detached from the ACT! SQL Instance. This has also been seen where the .ADF file is listed in the error message instead of the .ALF file.

    You can restore a backup to resolve this issue. If you do not have a current backup of this database, you will need to contact ACT! Database Services at to recreate the .ALF file.

    Author Comment

    Thanks for the information GL... Sorry to hear that I needed to copy down the .ALF file as well.. Figured I could just go with the two databases and it would recreate upon opening them.  I know now for the future.  Thanks for the help!
    LVL 1

    Expert Comment

    Thanks, took care of an issue for me as well.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    759 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

    9 Experts available now in Live!

    Get 1:1 Help Now