| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 71874 | 2006-08-20 07:09:00 | Medical database using access | Ripdog (11014) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 479675 | 2006-08-21 05:51:00 | My biggest gripe with Access is that a lot of designed functionality is broken with each upgrade that MS produces, necessitating that you either refuse to upgrade your version of Office, or you surrender to the costs of fixing issues that you create when you or staff 'upgrade' to MS's latest and greatest incarnation... often for no other reason than the upgrade was on sale. I'm looking at the potential of Open Office to replace all my personal database work in the future. Paul The constant upgrading of ACCESS is yet one more reason why people should consider MSWORKS for flat file databases. Upgrading is not a problem I find - all versions seem happy to work together. The mention of Open Office interests me. The last time I looked at Open Office I could find no database - apparently there was already a free one available so there was no need to have yet another. The one recommended I found to be as difficult as ACCESS to understand. Have things changed? I also wonder if the request for a medical database may actually be a request for running a shop for herbal remedies etc. Or even vibrating cushions. No need for massive security or expensive programs in that case. However I do agree - the best way to keep information secure is to stay off the internet - after all a cheap second hand computer can handle databases with no problems. Tom |
Thomas01 (317) | ||
| 479676 | 2006-08-22 03:58:00 | A cheap second hand computer can handle databases but what happens if it breaks and you can't access your patient files? I would have the following requirements of any database for such sensitive information: It must be fault tolerant and have extremely high availablity. Both you and some sort of deputy should be able to access the information in the event of an emergency without fail. It must keep private data that way. It should not be installed on a system connected to the internet unless as part of a high security network with proper protection (Hardware firewall, IDS, log monitoring, 24/7 technician access, etc). It should not be restricted by third party commercial interests. In other words, you must have access to the data in an open format on demand. This should be a part of a contract with any third party. Flat file databases will all fail the first unless you have daily off-site backups. These backups should be encrypted to satisfy the second requirement. MS Access doesn't properly meet the third. This would rule it off my list. A good commercial service should be able to meet all three requirements. Just check your contract carefully! |
TGoddard (7263) | ||
| 479677 | 2006-08-22 06:44:00 | You would find SQL data base system more to your liking,I would give it a go. Some might say,Access on steroids. |
Cicero (40) | ||
| 1 2 | |||||