Community
Showing results for 
Search instead for 
Do you mean 
Reply

Help in Reconnecting DB

Accepted Solution Solved
New Member
Posts: 2
Country: USA
Accepted Solution

Help in Reconnecting DB

Using ACTDIAG I disconnected oour active db because the ADF file was locked and could not be backed up. When I attempted to reconnect after the backup (by opening the ADF file from within ACT) it won't reconnect. Error says "This database cannot be opened because the SQLServer verison of this database cannot be identified.  Using ACT 2010 Version 12.1.181.0 Hotfix 1.

 

I'm stuck. Any help appreciated.


Accepted Solutions
Solution
Accepted by topic author dsteinbeck
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Help in Reconnecting DB

Hello dsteinbeck,
Welcome to the ACT! Community. Here a couple of things you can try:

Attach the database using latest ACTDiag version:
- Download the ACTDiag utility attached to this Knowledgebase article:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2760...
- Open the tool by double-clicking the icon (not by typing 'actdiag')
- Go to Tools > Attach ACT! Database > Normal Attach and attempt to attach your .ADF file

If this fails, the rename the .ALF file for your database, and in ACTDiag, go to Tools > Attach ACT! Database > Missing Log File

If this does not work, then you will most likely need to restore a backup of your database.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

View solution in original post


All Replies
Solution
Accepted by topic author dsteinbeck
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Help in Reconnecting DB

Hello dsteinbeck,
Welcome to the ACT! Community. Here a couple of things you can try:

Attach the database using latest ACTDiag version:
- Download the ACTDiag utility attached to this Knowledgebase article:
http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2760...
- Open the tool by double-clicking the icon (not by typing 'actdiag')
- Go to Tools > Attach ACT! Database > Normal Attach and attempt to attach your .ADF file

If this fails, the rename the .ALF file for your database, and in ACTDiag, go to Tools > Attach ACT! Database > Missing Log File

If this does not work, then you will most likely need to restore a backup of your database.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 2
Country: USA

Re: Help in Reconnecting DB

That worked - thank you. I did not think to check the verison of ACTDIAG.