Cannot open Act database from remote computer using VPN

Posted on 2009-02-11
Medium Priority
Last Modified: 2013-11-24
I have a remote computer trying to connect to an Act! Database through a VPN connection. The office where the computer is connecting to is on a workgroup network and are successfully sharing the database with two users (one serving as the main computer where the database is shared out, and another computer in the office which has no issues connecting to the database). All three computers are running the same version, ACT! 2008 Premium. The VPN connection seems to work fine as I can connect to the computer in the office and can see the shared database. When I connect to the database it requests the username & password. I have entered the proper username and password, but after doing that I get the error message:

"Cannot find database supplemental files folder _database name_ database files in this location _ComputerName_. This could be problem with the share, or the folder may not exist. Please contact the administrator of your database."

Any suggestions?

Question by:Jacobh06
  • 3
  • 2
LVL 30

Expert Comment

by:Mike Lazarus
ID: 23620084
Can you open the PAD file (in Notepad) and change the Host from the machine name to the IP address... this often works better with VPNs

Author Comment

ID: 23625278
Nope... I still get the same error. Any other possible solutions?

I appreciate the help.
LVL 30

Accepted Solution

Mike Lazarus earned 420 total points
ID: 23628700

Author Comment

ID: 23629702
That worked... when setting the IP address, I found out that I had to change the Database location to IP address also and configure the SQL port too.


Author Closing Comment

ID: 31545738
Thank you for the help!

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Integration Management Part 2
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month16 days, 5 hours left to enroll

850 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