I currently have a database running on Filemaker 5 that deals with criminal background checks. The system is really outdated and slow, so it is definitely in need of an update. The workflow is as follows right now:
- Client sends request for background check on John Doe
- Employee goes to court house and looks up information about John Doe
- Employee returns to office and enters information into FM database
If I could cut out the part where employees need to return to the office to enter information, it would save me a lot of time and money.
The most obvious method to accomplish this would be to connect a filemaker 11 server to one of my dedicated IPs and use web publishing to allow users to access the database.
My questions are as follows:
What is the most cost efficient machine I can purchase to act as the server?
(mac vs pc, brand, model, etc)
Also, right now, only 4-6 users access it during a given day if it matters.
What is the best way to make it secure?
I have a lot of very confidential, personal information in this database so I need to make sure only employees can access it.
Thanks for the help, Mike