Got 'cha! With either Access or many database packages you can have the data files on a server that is available to anyone on campus (who knows it's there) who has the database software on their computer. I can even VPN to that server from home and since I have Access on my home computer also, I can access the records. Check with your Information Technology people and I'm sure they can fix you up. If you need to tighten down for security, you can password protect the data file. dave David M. Porritt, RPT dporritt at smu.edu<mailto:dporritt at smu.edu> From: caut-bounces at ptg.org [mailto:caut-bounces at ptg.org] On Behalf Of D Marie Jones Sent: Saturday, January 23, 2010 12:48 PM To: caut at ptg.org Subject: Re: [CAUT] web-based record keeping system?? Hi Dave, Thank you for your feedback. Good question-let me clarify what I mean by "everyone": those of us who have direct contact with the pianos (techs, the director, possibly faculty). Not the general public, or even the general College. Our main issue is that we have 2 techs, no office, no dedicated computer to work from, and are trying to create a way where we can quickly & easily update the piano info instead of sending our notes to someone who then has to put them into a system. Historically, 1 tech has kept hand-written notes on all of the pianos. This system is no longer working. The only program I've used in the past is Filemaker, which is great, but needs to be used from one computer. . . I'll check out Access, thanks. take care---d D Marie Jones, RPT ________________________________ From: dporritt at mail.smu.edu To: caut at ptg.org Date: Sat, 23 Jan 2010 12:28:46 -0600 Subject: Re: [CAUT] web-based record keeping system?? For several years I've used Access for my piano records at SMU and I have the data file on a server on campus that is accessible to anyone there. It can also be seen outside if one uses a campus VPN. I haven't seen the value in posting it for general consumption. They are our pianos and our data so I see no need to share that with outsiders. What are you trying to accomplish by having it available to everyone? dave David M. Porritt, RPT dporritt at smu.edu<mailto:dporritt at smu.edu> From: caut-bounces at ptg.org [mailto:caut-bounces at ptg.org] On Behalf Of D Marie Jones Sent: Saturday, January 23, 2010 11:39 AM To: caut at ptg.org Subject: [CAUT] web-based record keeping system?? Hi everyone, I am wondering if anyone is using / has developed a web-based record keeping system for all of the pianos maintained at your University / College. We, at Kalamazoo College, are in the nascent stages of trying to develop a system that multiple users can access / make notes on / read piano updates while the main purpose is to keep our notes on every piano (tuning, repairs, etc.) and continually update these files. Any suggestions or sharing of the system you use at your school would be most helpful. I realize the web-based idea may not be viable, but curious to know who is using what with how much success prior to inventing the wheel. . .over & over again. . .thank you! take care---D Marie D Marie Jones Piano Technician, RPT, MFA Kalamazoo College 269-383-0620 269-806-4067 (cell) ________________________________ Hotmail: Trusted email with powerful SPAM protection. Sign up now.<http://clk.atdmt.com/GBL/go/196390707/direct/01/> ________________________________ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up now.<http://clk.atdmt.com/GBL/go/196390709/direct/01/> -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://ptg.org/pipermail/caut.php/attachments/20100123/a4d2d02b/attachment.htm>
This PTG archive page provided courtesy of Moy Piano Service, LLC