07-08-2013 09:19 AM
Pardon me if this has been answered. I cannot seem to find a remedy that makes sense.
My ACT! database resides on a logical drive,N:. I am trying to move it from one logical drive to another larger one. I know copying the files and renaming the new drive to N: won't work. Why?
Anyway, I backed up the database and tried to restore it on the new drive but received a "Failed to open a connection to the database" error.
The database opens on the original drive, so it is *not* the ACT! or SQL installation.
There is no database connected to unattach.
What should I do?
07-08-2013 09:19 AM
Sage ACT! Premium 2012 Version 18.104.22.168, Hot Fix 5 (Normal Use)
Sage ACT! Premium 2012 14.0.572.0 Hot Fix 2 (For Importing Contacts)
Win 7 Pro SP1 x64
Outlook 2010 x32 v14
Durkin Impact Business Suite V4.2
Exponenciel Automatic Field Calculations v8.5
Company Wizard v22.214.171.124
Duplicate Wizard v126.96.36.199
07-08-2013 11:20 AM
I'm not totally sure of what you mean by logical drive. The drive needs to be located on the machine. Not a network drive or a drive on a thumb drive or a drive on a network storage device.
to move it, there are several ways. Here is what is easiest for me.
1) open actidiag (start, run, actdiag)
2) go to the database tab. note the location of the database. Browse to that folder.
3) make sure you see an .alf, .adf and supplemental files folder (database name - files)
4) Go back to ACT diag and right click on the database and choose detatch database
5) go back to the folder location and move all files for the database to the new location. You don't need the .pad file. and can delete this one.
6) with all files in the new location, start ACT (you will get a database not found message.)
7) Go to file, open and instead of opening the .pad file, open the .adf file
this will re attach your database to the SQL and open your Database.
07-08-2013 03:34 PM
The database was not there to detach.
If I try to open the ALF file I get the error "This file is in use. Enter a new name or close the file that's open in another program."
If I try to open the PAD file I get the error "The database... could not be accessed. In order to access this database, check your network connection and verify that your database server is available. It may be necessary to disable any firewall software on your computer or the server."