Community
Showing results for 
Search instead for 
Do you mean 
Reply

Pseudo networking using a database on mapped network drive

Accepted Solution Solved
Copper Super Contributor
Posts: 34
Country: United States
Accepted Solution

Pseudo networking using a database on mapped network drive

Act standard will not let me create a new database on a remote mapped drive. Are there any workarounds?

 

I want to put a database on mapped Z: and be able to open it from 2 computers (but only one at a time.) I will open it on one computer, close it, then go to another computer to work on it. That way 2 users can have a constantly updated database. One person works in the morning, the other works in the evening. No need for the expensive premium or constantly running server.

 

I started by making a new shared database and adding another user with admin rights. Then I copied the database-files folder and adf, alf, and pad files to a location on the Z: drive. ACT did not like that. When I went to the second computer and tried to open it, it reported that access to some files was missing (it was looking back at the origin computer location where it was created, not to where it was currently setting.) Therefore ACT is storing paths in the database pointing to where it was originally created (when you look under help>about>database info). Is there an addon or other solution to modify the database to make it look on the remote z: drive for everything it needs to run smootly? Or is my only solution to set up a constantly running server and use the method of server / remote database with periodic synchronizing.

 

PS The Z: drive is a network appliance drive, not a computer with an OS.


Accepted Solutions
Solution
Accepted by topic author vcli
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Pseudo networking using a database on mapped network drive

ACT! uses MS SQL, which is a client server database and needs services to on the local machine to run

 

You can't put it on a network appliance drive. It has to be locally on a Windows machine.

 

You could leave it on your PC and have the other user access it from there. Make sure it's saved in a folder outside of My Doc (My Docs doesn't share easily). Then follow this ACT! Knowledge Base article - http://tinyurl.com/67ngxd

 

To move the database to a different machine (must be running ACT!) or a different folder, you can't just copy the files. See this ACT! Knowledge Base article - http://tinyurl.com/62cvmo

View solution in original post


All Replies
Solution
Accepted by topic author vcli
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Pseudo networking using a database on mapped network drive

ACT! uses MS SQL, which is a client server database and needs services to on the local machine to run

 

You can't put it on a network appliance drive. It has to be locally on a Windows machine.

 

You could leave it on your PC and have the other user access it from there. Make sure it's saved in a folder outside of My Doc (My Docs doesn't share easily). Then follow this ACT! Knowledge Base article - http://tinyurl.com/67ngxd

 

To move the database to a different machine (must be running ACT!) or a different folder, you can't just copy the files. See this ACT! Knowledge Base article - http://tinyurl.com/62cvmo

Copper Super Contributor
Posts: 34
Country: United States

Re: Pseudo networking using a database on mapped network drive

Ok, Since the 2 computer are laptops that go home each day, I will have to set up a constantly running windows xp pro machine on our local network to run as an ACT server.
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Pseudo networking using a database on mapped network drive

Or have the two users (if that's all you have) to sync with each other when both on the LAN.... and have one make sure to do backups to a folder on the NAS