OK, and please correct me if I am wrong Roy. Remember, I do not use the ICD-9 codes, do not understand them, and think they are crazy. But, of course, I wanted to try. Just in case I wanted Acute Otitis Media and Otitis Media, Acute. Not sure if this will work -- I tried it 100 times. And, it may be a stupid way.
If you go to the chart and click on Find Diagnosis just as if you were going to pick a diagnosis, and ummm pick a diagnosis. Say Upper Respiratory Infection 465.9 (Sorry if wrong code)
If you have Upper Respiratory Infection in the Search Database, and you go to edit and type in URI and then 465.9 and click Edit, you will end up with URI 465.9, but the Upper Respiratory Infection will be gone. This is because it was it in the window and highlighted, et al. and the program thinks you don't like the name so it edits it. If on the other hand, you type an O in the top field, so that Upper Respiratory Infection disappears deep inside the cozy confines of Microsoft Access Land and then you type in URI and edit, you will now have 465.9 bringing up both. Don't ever use Add from my experiences. So, best I can do. Play around with it and see if Roy has a simpler and better way. I am sure there is.
FTP means you will need to upload the file to a site using an FTP client so that others can download it. Unless you have it set up, it is, in my opinion, not worth it. I would simply email, but if you have Outlook, you may have to tweak the registry at a Level1Remove or change the extension to .bmcd or something. The other alternative is to zip the file, which would be the easiest.
@Leslie...AARRGGHH!! Sorry about the overwrite. And, without going into my spiel about 85 backups --- I should mention when I talk about backups, I am talking about the mundane, day to day, backup in case something happens to your whole computer or AC. But, if you have a file (database) you have put a lot of work into as you had or one like Roy's or Brian's, then that one should be copied and put in several places. You can bet my AmazingMeds database is on the server but also on my home computer and burned to a few CDs. I dont know why AC would overwrite it. Databases shouldn't overwrite another database as another file may. It may be possible that the new one was structurally different. My recommendation would be that prior to any download, you back up the entire folder or at least rename the important databases, i.e. AmazingCharts and Codes or whatever from .mdb to .original or .old. This way AC won't know who the hell they are. It will just install and look at those weird files and say, "gee, I don't remember Jon making those, but I guess they can stay."
The other thing, and I am not saying that may way is the only way, but I never download a new copy onto the server. The server has my AC folder and that's all. There is no program on the server. All of the updates and upgrades are for the program functionality only and are installed on the clients where I then just tune to the server. Of course, this is assuming a client/server set up and not a peer to peer where the computer hosting the database is also in use. Of course, even in a peer to peer, the pseudoserver can still be used to run the program only.
Roy, great story on Pooh. Which reminds me. I will go find the story of Pooh on one of the journals done by a group of psychiatrists. It's incredibly funny. Of course, the comments the next month ranged form incredibly funny to my kid read that and was depressed for weeks.
