Home Forums Discussions General Discussion Jon has more power in SQL express-what do you want

No. I just have a problem installing it period. Gives me an installation error about using .msi another form of the Microsoft installer package.

Thanks Bert, for now I will run on V3.7 and will try running the AC4 from my server's D disk sometime later this week when I have the time (it took almost 2 hours to the migration).
Francisco

It took ten minutes for me, but I am still waiting a bit longer at least for the non-Beta version.

I have tried the V4 beta version. I do not want to go back to that horrible medication database. If there is a way to edit/delete/add to the medication database, I'd love to hear it. Is it possible to separate the medication database from the rest? Could there be an option to choose an alternative database? I'd rather keep my present medication database and link it to V4. I don't know if an access database can be linked to an SQL database.

I'm SQL IgnOrAnt

billl,

There are many ways to work with SQL, some of which you mention. I know that you can't just stick the Access in there. I have tried converting the Access database to SQL. Part of that problem is I have to go back to the version I made and convert to the format that Jon is using now. It works when I convert it to SQL (easy in Access to do -- there is a wizard), but for some reason the program crashes ONLY when I go to the admin section. Works fine otherwise.

Unfortunately, I am as IgnOrAnt as you. I am learning though. And, I have my programming friend on it. There are also some other things in the works, but I can't go into those right now.

To be honest,until then, I am like Patrick Henry. Give me my medication database or give me V3. Or did he say, I only regret that I have but one life to give for my country?

Need the pharmacy name field on script pad.

Out of curiosity, why? I thought the point of printing scripts was so that patients would have a choice of pharmacy.

Bert, my youngest son's name is Patrick Henry. But he is 8 and says, "Gimme Skittles or give me death," or something like that.

I think Joseph is talking about times when you want to insure that the patient goes to a particular pharmacy, especially as Jon is making scripts that can be tamper proof. (I think). And, I shouldn't speak for Joseph, but this has come up before.

Also, there is a field in demographics where you can enter what pharmacy the patient prefers. This is of little help when you are busy. It shouldn't automatically populate the actual script, but it would be nice if it popped up in case you needed it.

This would serve two purposes. One, if there is a time that you need to fax/call in a script and you can't get hold of the patient again (say someone forgot to get the name of the pharmacy), you can at least have some idea. PLUS, if you do fax your scripts, and you say to a patient (especially a healthy one who hasn't been in for six months), "I can fax this for you. You use Riteaid on Main St, correct," which will impress some patients.

Benjamin:

This is solely for faxed scripts.

One of the laws per pharmacists is that when we fax a script, it needs to say the name of pharmacy. Alternative is to send a cover sheet with each faxed script saying it was meant for that pharmacy.

Joseph,

You're kidding? They make you write the name of the pharmacy? What is the difference between that, and the fact that the pharmacy's fax number is on the top of the page?

That seems crazy.

So, does this mean if some hacker can fax from home and make it look like it came from your office, their putting the pharmacy name on it will stop them? Wouldn't they know what pharmacy it is going to?

Now, putting the name on a script which you hand to the patient makes much more sense.