Database updates & viewing with multiple users

Family Mailing List, Personal Profiles, Activities and Skills, Attendance, Visitations

Moderators: Moderators, Tech Support

Database updates & viewing with multiple users

Postby bookkeeper-sheila » Sat Sep 24, 2011 8:31 am

(Version 11 with maintenance releases)
Our church now has two users entering in membership info into the database, which is stored on a separate computer (our "server"). We are finding that only one can be in at a time doing updates. When one person is updating, the other can type but then at the save point is kicked out of powerchurch with an error that there is not enough disk space; The latter must then re-login and retype information when the other person is not in the module. Is there a way around this? perhaps a network setup?

Also, we are thinking of adding the administrators of the preschool as users, but to view the database only. If we do this, will it slow Powerchurch down? If they are viewing a record, will it lock everyone else out of the membership module???

Just wondering...these are wonderful growing pains for us...
Bookkeeper-Sheila
Switzerland Community Church
bookkeeper-sheila
 
Posts: 64
Joined: Tue Mar 24, 2009 3:29 pm
Location: Switzerland, FL

Re: Database updates & viewing with multiple users

Postby NeilZ » Sat Sep 24, 2011 11:33 am

bookkeeper-sheila wrote:(Version 11 with maintenance releases)
Our church now has two users entering in membership info into the database, which is stored on a separate computer (our "server"). We are finding that only one can be in at a time doing updates. When one person is updating, the other can type but then at the save point is kicked out of powerchurch with an error that there is not enough disk space; The latter must then re-login and retype information when the other person is not in the module. Is there a way around this? perhaps a network setup?

Also, we are thinking of adding the administrators of the preschool as users, but to view the database only. If we do this, will it slow Powerchurch down? If they are viewing a record, will it lock everyone else out of the membership module???

Just wondering...these are wonderful growing pains for us...


This sound like a file locking issue, but additional information can help:

1: What Operating System is the 'server' using?
2: Did you use the network setup as shown here:
http://www.powerchurch.com/support/kb/k ... icle_id=33

Plenty of users are doing exactly what you're doing without problem, so I do suspect a setup issue.

As to your last question, there will be some slowdown, but it should be negligible as it would be due to hard disk access as well as network speed.
Neil Zampella

Pastor's Spouse,
Connellsville Presbyterian Church
Using PC+ since 1999.
NeilZ
 
Posts: 4637
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

Re: Database updates & viewing with multiple users

Postby Tracy » Mon Sep 26, 2011 9:23 am

bookkeeper-sheila wrote:(Version 11 with maintenance releases)
Our church now has two users entering in membership info into the database, which is stored on a separate computer (our "server"). We are finding that only one can be in at a time doing updates. When one person is updating, the other can type but then at the save point is kicked out of powerchurch with an error that there is not enough disk space; The latter must then re-login and retype information when the other person is not in the module. Is there a way around this? perhaps a network setup?

This happens when the server has the "Enable write caching on the device" Policy set in Disk Management for the hard drive the data exists on. If you are uncertain about what to change, you'll need to speak with a local computer person to verify this setting is turned off.
This can also be caused by anti-virus programs occasionally locking files when it is changed. The best thing is to set exclusions for the PowerChurch folder, and for the following extensions: *.DBF, *.CDX, *.FPT, *.PCA.
This can also be caused by on demand back up utilities. If you have an on demand back up, change it to back up the PowerChurch folder after the people that usually access the data have gone home. Many of these utilities will lock the file preventing writes, as the back up the file.
Tracy
Tracy
Program Development
Program Development
 
Posts: 476
Joined: Fri Sep 05, 2003 2:08 pm
Location: PowerChurch Software

Re: Database updates & viewing with multiple users

Postby bookkeeper-sheila » Mon Sep 26, 2011 10:33 am

Thanks to both of you...I will troubleshoot and reply back when I can...
Bookkeeper-Sheila
Switzerland Community Church
bookkeeper-sheila
 
Posts: 64
Joined: Tue Mar 24, 2009 3:29 pm
Location: Switzerland, FL


Return to Membership