Database updates & viewing with multiple users

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

Moderators: Moderators, Tech Support

Post Reply
bookkeeper-sheila
Posts: 64
Joined: Tue Mar 24, 2009 4:29 pm
Location: Switzerland, FL

Database updates & viewing with multiple users

Post by bookkeeper-sheila »

(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

NeilZ
Posts: 10427
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Database updates & viewing with multiple users

Post by NeilZ »

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

Using PC+ since 1999.

Tracy
Program Development
Program Development
Posts: 463
Joined: Fri Sep 05, 2003 3:08 pm
Location: PowerChurch Software
Contact:

Re: Database updates & viewing with multiple users

Post by Tracy »

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

bookkeeper-sheila
Posts: 64
Joined: Tue Mar 24, 2009 4:29 pm
Location: Switzerland, FL

Re: Database updates & viewing with multiple users

Post by bookkeeper-sheila »

Thanks to both of you...I will troubleshoot and reply back when I can...
Bookkeeper-Sheila
Switzerland Community Church

Post Reply