Cannot open Act database from remote computer

I am having issues with Act for Workgroups 9.0 not opening from a remote computer. If I am on the server where Act is installed the database opens fine but for some reason when I try to access it from a   remote computer via a share it does not open. It was working and for some reason it stopped.

I thought that there might be something wrong with the server that it is running on so I moved the database files to another server and I still get the same error. Here is the error message the remote computer gets when it tries to open the database:

The database "database name" 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 server.

There is no firewall running on the server or the workstation. I have also tested accessing the share from the workstation to the server and it works fine. The user can create files and delete files without any issues.

Any help on this would be great.

Who is Participating?

Most of these errors are caused by permissions or DNS issues.  Make sure the remote user has full permissions to the database share and supplemental file folder.  Also, without DNS ACT! won't be able to open the supplemental file folder.  You should be able to ping the machine name.  (C:\>ping servername).

Try that and report back your results.

thinksysincAuthor Commented:
@GLComputing - That document was very helpful. My issue was with the SQL Browsing service. Thanks!

@SStroz - Thanks for the help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.