?
Solved

ACT2005 database unable to open

Posted on 2009-04-16
25
Medium Priority
?
384 Views
Last Modified: 2013-12-12
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".  
0
Comment
Question by:upstream123
  • 13
  • 7
  • 5
25 Comments
 
LVL 3

Expert Comment

by:madmark75
ID: 24163016
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
 

Author Comment

by:upstream123
ID: 24163044
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
 

Author Comment

by:upstream123
ID: 24163063
the server 2003 is on new pc
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 3

Expert Comment

by:madmark75
ID: 24163399
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24163417
0
 

Author Comment

by:upstream123
ID: 24163448
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24163520
Did you see the link I posted about changing the machine name?
0
 

Author Comment

by:upstream123
ID: 24163595
the machine name is the same on the server as in the pad file
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24163804
0
 

Author Comment

by:upstream123
ID: 24163828
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
 
LVL 3

Expert Comment

by:madmark75
ID: 24164128
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
 

Author Comment

by:upstream123
ID: 24188219
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
 
LVL 3

Expert Comment

by:madmark75
ID: 24188683
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
 

Author Comment

by:upstream123
ID: 24188694
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
 

Author Comment

by:upstream123
ID: 24189249
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24189304
Are you running the Premium version of ACT!?
0
 

Author Comment

by:upstream123
ID: 24189345
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24189803
If it's not the Premiuym version, your IT isn't correct... ACT! 2005 only used MSDE unless using the Premium build
0
 

Author Comment

by:upstream123
ID: 24189813
i know it worked previously with XP.  i do i tell if it's premium?
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 24189845
Have a look at Help | about
0
 

Author Comment

by:upstream123
ID: 24189852
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
 
LVL 3

Expert Comment

by:madmark75
ID: 24197186
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
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 2000 total points
ID: 24231535
0
 

Author Comment

by:upstream123
ID: 24330196
i can open the DB on the server, but still can not open it from my client pcs
0
 

Author Closing Comment

by:upstream123
ID: 31571223
the link you sent worked...the file was suspect. thanks a million!!!!!!!!!!!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Have you ever run into that annoying problem where the computer won't boot?  Wouldn't it be great if you had a tool that would make that disk boot again?  I have found one tool that works more often than not ...
Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

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