ACT Version 8 - Get "the database could not be accessed"  when trying to open on a new machine.

Posted on 2007-07-30
Last Modified: 2010-05-18
I've just upgraded a client of mine's computer... well basically re-did their server and had to re-add them to the domain etc.

Everything is working fine with the computer except for ACT... so the pressure is on me to get this back up and running.

Currenly when I try to open either the PAD (locater) file or the ADF (data file) I get the error:

"The database horton 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 diable and firewall software on your server"

I've tried simple things... like changing the computer name back to what it was previous, trying to force open the ADF file... all with the same result.

Any help would be appreciated.

Question by:Fluid_Imagery

    Author Comment

    This is driving me nuts!

    Author Comment

    I got the database working again.

    There must have been a problem with the file replication between the server and the local computer.  I noticed that the file size on the two different locations were off by about 100KB out of a 48mb file.  I copied the ADF and ALF to the same spot... erased the PAD file and it did the trick.
    LVL 30

    Accepted Solution

    If moving a file from one machine to another, you really should do a Backup, then Restore_As... the machine name is in the database and only this method will properly change it

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article describes some very basic things about SQL Server filegroups.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    779 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

    10 Experts available now in Live!

    Get 1:1 Help Now