Hopefully helpful and not condescending.
Open Office has a database editor, but you would want to do it in Access.
Now, I simply don't know why you would not want to use your new database. I will give you two HUGE reasons why you should. This is not like entering commands into a Cisco PIX firewall during lunch on your busiest day of work, lol.
Reason number one:
I will make this foolproof. Not like the instructions I just posted in the Tips and Tricks forum. Rather than use Formulations, Listings, MedNames and MedDetails, I will use 1, 2, 3, 4 as they come this way as tables on the left. So, it would look like:
1
2
3
4
Now, numbers one and two are VERY important. Lose though with no backups and ALL your work is gone forever
Number 2 is your very important one as it is your LISTINGS. Clicking on it will LIST your medications. Brian, you must have clicked on this hundreds of times to add meds.
So, let's go through the step of adding a medication minus the detail of how to put the actual formatting in.
Step 1: Click on Listings
Step 2: Enter medication
Step 3: Right click on #3 and #4 and press delete.
Step 4: Click save and close the database. That's it!
I wish it were harder so I would look really smart, but it's not.
Reason number two:
So, you have your AmazingMeds.mdb database on your desktop. You make one change or hundreds. It is now saved on your desktop and, as you say, 100% better than the ghost of itself that still resides for reasons unknown in the AC folder.
So, open the folder and take it out. Put it somewhere besides your desktop or Windows will get very confused and ask you if you want to overwrite the one on the desktop. So, put it in My Documents or rename it. Now put your 100% better one in the folder. Use Amazing Charts. See all your new meds in the prescription writer. Notice all the meds that aren't there.
Now, let's say you accidentally deleted the formulations table in your new database. What would happen when you opened AC? Nothing? What would happen when you opened a chart? Nothing. What would happen when you opened the script writer. Error message. Followed by AC crashing. Well, your application on your computer would crash. Nothing would happen to your folder on the server. It would crash because when you opened the script writer, AC was looking for four tables. And, formulations wasn't there, and it confused AC so it just got angry and decided it didn't want to play. It took its script writer and went home.
So, you put the other database in and everything's good. Or you could even copy the formulations table into your new database in AC.
There is absolutely nothing to worry about. Nothing. Trust me. Now if you had SBS running and were using Cisco PIX and told me you wanted to allow Remote Web Workplace to run, I would not give you the command:
access-list outside_access_in permit tcp any host 72.xx.xxx.32 eq https
and expect you to enter it even though I know it would work.
Anyway, good luck!
And, I am just having fun. I am not trying to be condescending or cute.
