Community
Showing results for 
Search instead for 
Do you mean 
Reply

Is it possible to share an ACT v11 2009 Db between 2 computers without Remote Synchronization?

moo
New Member
Posts: 3
Country: USA

Is it possible to share an ACT v11 2009 Db between 2 computers without Remote Synchronization?

Hello All,
 
First, as a noob ACT maintainer, let me say thanks for providing this excellent community as a resource for ACT users!
 
I just began supporting a small office where the users rely on ACT 11 2009.
 
Their systems are:
2 PCs with Windows 7 Pro
- both located on same Ethernet subnet
- 1 PC running the MS SQL ACT database service, the other is not.
 
It seems that past sysadmin set them up in the distant past to use simple Windows file sharing to share their ACT database.
Of course, this arrangement stopped working just recently, and I'm trying to figure out how they SHOULD be configured.

 

Is it possible for the two computers to be sharing the database without using remote synchronization?

 

Thanks in advance for any pointers,

 

Jason

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Is it possible to share an ACT v11 2009 Db between 2 computers without Remote Synchronization?

Yes.  They can share the database without remote synchronization.  Basically the publisher has SQL installed and the client accesses the database using the SQL that is installed on the publisher's system.  There are a lot of reasons why it might not be working.  Microsoft has been messing with security quite a bit over the last few months and it is causing a lot of headaches for Act! users because they used to have access to processes and folders that they no longer have access to.  If the fix is going to be a simple one the way to fix it is to go to Tools | Maintenance on the machine where Act! is installed and turn sharing on if it is off and turn it off and then back on if it is on.  If that doesn't work you will need to get an Act! consultant to help you out or you will need to read the KB articles in www.actkb.com to determine what the issue is.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
moo
New Member
Posts: 3
Country: USA

Re: Is it possible to share an ACT v11 2009 Db between 2 computers without Remote Synchronization?

Thank you very much Stan!

If the Tools --> Maintenance --> Sharing menu item is grayed out on the "server" machine, can I re-enable it somehow?

Best regards,

Jason
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Is it possible to share an ACT v11 2009 Db between 2 computers without Remote Synchronization?

In order to share it you must be logged in as an Act! administrator.  That's probably why it is greyed out.  If that isn't it try launching Act! in administrative mode.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
moo
New Member
Posts: 3
Country: USA

Re: Is it possible to share an ACT v11 2009 Db between 2 computers without Remote Synchronization?

Thank you Stan!