Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
neonkian
Posts: 1
Country: USA
Message 1 of 9 (604 Views)

Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

I am trying to open a database that was created in ACT 2007 (I think that was the version) in my ACT 2010.  When I click on the ADF file of the database to open it in ACT 2010, I get an error msg stating "the .ALF file can not be found. This is not a valid ACT database.".  I was given the ADF file on a thumb drive and the .ALF file is located on there. How do I match the .ALF file with the ADF file so that I can upgrade and open the database in ACT 2010?

Please use plain text.
Copper Super Contributor
rkumar
Posts: 78
Country: Australia
Message 2 of 9 (596 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

Copy both the .alf and the .adf files to a directory in your C:\. Open it from there and it should work. Those files just have to live in the same place.

Please use plain text.
New Member
dbayc10
Posts: 3
Country: USA
Message 3 of 9 (462 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

My error message is the same, "The .ALF file cannot be found. This is not a valid ACT! database." -   but I have only the .ADF file.  The other files are gone. How can I open it? It's a 40 MB file. 

Please use plain text.
Platinum Super Contributor
gmartin
Posts: 5,276
Country: USA
Message 4 of 9 (453 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

Hello Dbayc10,

Welcome to the Sage ACT! Online Community!

 

Here is an article with instructions for using the updated 'ActDiag' utility, it contains an option for Attaching an ACT! Database without a log file (*.ALF): KB Article 27607

 

Use section titled: "Attach database to SQL".

 

Greg Martin
Sage
Please use plain text.
New Member
dbayc10
Posts: 3
Country: USA
Message 5 of 9 (447 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

Thank you.  However, attempts to attach the database, 'in the case where no .ALF file exists', resulted in an error, "The log number ( ) passed onto log scan in database ___ is not valid." 

David

Please use plain text.
Platinum Super Contributor
gmartin
Posts: 5,276
Country: USA
Message 6 of 9 (435 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

For this issue, you will need to contact our Database Services group so they can attempt to correct the problem with the database file (ADF).

 

Database Services can be contacted through the instructions in this article: KB Article 24758

Greg Martin
Sage
Please use plain text.
New Member
dbayc10
Posts: 3
Country: USA
Message 7 of 9 (431 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

Thank you.

I will try to have Sage repair the db.

David

Please use plain text.
New Member
imather
Posts: 1
Country: USA
Message 8 of 9 (124 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

gmartin,

 

Thank you for helping us on this issue.

The link to your referred article is broken. How might i find the article? Could you refer me to that article/a working link?

I am experiencing a similar issue as Dbayc10, and would like to open am .adf file without the associated .alf file.

Help!

 

Feel free to reach out to me at isaac.mather@marcusmillichap.com with information and updates!

 

Kindest regards,

Isaac

Please use plain text.
Copper Elite Contributor
Jared Dalrymple
Posts: 138
Country: Australia
Message 9 of 9 (116 Views)

Re: Trouble Opening an old ACT database in ACT 2010 ".ALF File cannot be found"

Hi Isaac,

 

You can find all the old sage KB Articles on Swiftpage's new site kb.swiftpgae.com just by searching the article number.

 

here is a link for the one gmartin posted to get you started though http://kb.swiftpage.com/app/answers/detail/a_id/24758/kw/24758

 

hope this helps

 

 

Jared Dalrymple | Technical Consultant | P:+61 7 3423 3551
jared@evolutionmarketing.com.au | Evolution Marketing Services


Please use plain text.