ACT2005 database unable to open

I have been using ACT2005 with mulitple client PC's in an office enviroment with several uisrs accessing and updating the DB.  The DB is kept on my server.  Since upgradfing my server I can no longer access the DB from my client PC's.  I can log on to the server and open the file from there.  The error message I get is "could not access Specified DB".  
upstream123Asked:
Who is Participating?
 
Mike LazarusConnect With a Mentor Act! Evangelist - CRM ConsultantCommented:
0
 
madmark75Commented:
What updates/changes were applied to the server?

Also - On the Client PC's - Do you get the same error message when trying to browse to the PAD file on your server and open up the DB that way?
0
 
upstream123Author Commented:
windows server 2003 is the new server.  previously we used XP on the server.  All of the PC's that use tyo access this DB no longer can.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
upstream123Author Commented:
the server 2003 is on new pc
0
 
madmark75Commented:
Next few things to check if you haven't done so already:

Make sure the DB is enabled for sharing within ACT on the new server.  

Make sure all the users are setup in act on the server.

On the Other PC's (clients) make sure you can browse to the network location where the ACT DB located on the the server.  


See this Act link for more info acout Act and shared DB's:

 http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/popup_adp.php?p_faqid=13878&p_created=1120379860&p_sid=awNCMvvj&p_lva=15194&p_li=&p_redirect=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MjE3NCwyMTc0JnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1hY3QgMjAwNSBtdWx0aS11c2Vy
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
0
 
upstream123Author Commented:
as the admin, i can access any file on the server from my pc including the act database.  unfortunately i can't open it when i select the pad file.  my IT guy has given up as he can't understand why it won't work.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Did you see the link I posted about changing the machine name?
0
 
upstream123Author Commented:
the machine name is the same on the server as in the pad file
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
0
 
upstream123Author Commented:
i have to leave the office and won't be back until monday.  please leave any suggestions for me and i will check back when i am in on monday.  thanks for your help!
0
 
madmark75Commented:
Definitely check through the KB posting that GLComputing posted, especially in regards to the firewall and making sure the SQL services are running on the windows 2003 box.  I do recall there being some specifics when running ACT on 2003 Server and depding on if you were running SQL or MSDE.

Since it is a Windows 2003 Server upgrade and I am not sure if you are running Active Directory besides how the network is setup is it could possible be a DNS lookup problem, it all depends on how things are setup on the network, if you are now on a domain, etc.

If you are on a domain make sure the fully qualified domain name of the server is in the pad file.  When I ran into this problem on a network that was not in a domain I ended up adding the server and static ip address of the server to the windows host file.
0
 
upstream123Author Commented:
Every thing checks on so far on what has been suggested and it still isn't opening the file from the client.  Any more ideas?
0
 
madmark75Commented:
Are there any errors on the client pc's in the windows system and application logs that might point to anything when you try to open up the ACT that might point in a specif direction for things to check ?

Other than that, all I can think of is to check to make sure they are all running the same version of Act - including any updates that could have gotten put on the clients and not the server b/c you upgraded the server and also MSDE versions could be different b/c of the server upgrade and getting patched.

I worked through a bunch of crap with ACT 2005 with MSDE/SQL updates and then again when Act was upgraded to 2009 so I feel some of your pain.  I'm thinking it is most likely related to the MSDE/SQL portion of ACT provided the firewalls

The other thing to try if you don't want to muck around on the other clients just yet is to try installing Act again on a test machine - make sure it is the same patch level (ACT and MSDE/SQL) as the server and try to connec the DB.  If that works than I would say you are looking at uninstalling act ACT and MSDE/SQL and reinstalling.  (had to do that before too).  

0
 
upstream123Author Commented:
this is further info from my IT guy regarding your feedback.

You are running SQL on the server and not MSDE. Its actually ACT's version and configuration.
The firewall service has been disabled. I never run it on a server.
There is no Active Directory in use this is for domains. You are on a Workgroup so all is accessable.
The server is not running DNS the router performs that task as it always has.

0
 
upstream123Author Commented:
i installed ACT on another PC and tried to open the db on the server..  i get the same error
"could not access specified DB"
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Are you running the Premium version of ACT!?
0
 
upstream123Author Commented:
i am running act2005 version 7.0.399.0.  once upon a time i could access and work with the db viz my client pc's prior to upgrading to windows 2003
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
If it's not the Premiuym version, your IT isn't correct... ACT! 2005 only used MSDE unless using the Premium build
0
 
upstream123Author Commented:
i know it worked previously with XP.  i do i tell if it's premium?
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Have a look at Help | about
0
 
upstream123Author Commented:
nothing about premium is in the description.  i do know that this version worked with my server when it was an xp version.  would that make a diiference?
0
 
madmark75Commented:
Premium and ACT for windows would make a difference, Windows Server 2003 is more of the difference.

Did you already try putting the IP address of the server in the PAD file instead of the server name?  (Note: you will need to make sure that the server is setup with a static IP address and not using DHCP).

I'm assuming you have premium installed:  See this link for the install info, your IT person should know which version of Act it is, this is the link for the installation of premium.
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=13888&p_sid=FeK85Vvj&p_lva=13878&p_accessibility=0&p_redirect=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9NDEyMCw0MTIwJnBfcHJvZHM9NjUxMiZwX2NhdHM9JnBfcHY9MS42NTEyJnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTE%2A&p_li=


Other than that:
Go through the sage support pages and make sure all relevant kb's for your version of ACT are also folowed:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=13878&p_created=1120379860&p_sid=FeK85Vvj&p_accessibility=0&p_redirect=&p_lva=14468&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9NDEyMCw0MTIwJnBfcHJvZHM9NjUxMiZwX2NhdHM9JnBfcHY9MS42NTEyJnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTE*&p_li=&p_topview=1




After that, make sure the versions of ACT are the same on the server and workstation as the sate kb's state, this would also include any microsoft security updates regarding MS .net, sql service packs and updates.  If you are running a server I would give/or make sure it has a static ip address.  since you are not on a domain and the router and windows is handling server name lookups.

Other than that since ACT no longer supports 2005 you might be looking at upgrading to 2009.....especially if you want to keep applying security updates on your server and workstations b/c sooner or later even if you get it working it might break again....

I don't care too much for act mself, it does alot of nifty things, but supporting it is a pain and it definitely bogs down a system...Good Luck!
0
 
upstream123Author Commented:
i can open the DB on the server, but still can not open it from my client pcs
0
 
upstream123Author Commented:
the link you sent worked...the file was suspect. thanks a million!!!!!!!!!!!
0
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.