Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You may want to take a look at "Your Insurance Office" (YIO). I originally developed it in 1995 and it has been upgraded several times since.
Agents throughout the US and in eight foreign countries are now using it and love it. It is so simple to use that anyone who can use a keyboard and a mouse can load it and begin working immediately. Support is unlimited and toll-free.
Cust Serv is great, even at midnight. .
I exagerrated an hour. I believe it was 10:30 or 11:00pm. It was not YIO's fault. I was driving down the road to an appointment( something insurance agents do, Al) and had the pulled up on YIO. Of course I should have pulled over but I didn't. I have no idea what happened but I hit a button or a couple buttons, I don't really know, and I lost all my data. I also did not back up my files, I was freaking out. I called Frank and he told me to call him back when I wasn't driving. SO when I called him back it was about 10:30 or so. Anyway the problem was fixed and Frank found my data for me. That is the only problem in the 5 months I had it, which was my fault not YIO.What happened with YIO that you needed to call Frank at midnight? The Access back-end data-store go corrupt on you? Access has a long history of being easily corrupted. Fortunately most of the time it is easily repaired with a utility that Microsoft gives you. (I hope Frank does not use auto-sequenced record keys... 1,2,3,4, etc. as opposed to generating "real keys" like 2874lu76, 29asl873 because it is known to happen that even a 'repair' won't work on an Access table with auto-incremented primary keys. I don't know why. Anyway, no self-respecting programmer would use auto-increments as record keys so I doubt Frank did either.)
And this is not just an Access issue. No matter what data-store you are using, you should set up a procedure to take a backup every hour. I use an industrial-strength database called MySQL (MySQL AB :: The world's most popular open source database) which has a ton of internal 'controls' to keep it sound... but I still don't trust it and I have a very simple script to do what is called an sqldump of the data each hour. Should the crap hit the fan, it takes all of 2 minutes (granted my data base is not large) to regenerate a new version of the database and be up and running. Thus, worst case is I lose an hour of work... as long as the server is up!
I also have a copy of SugarCRM (which is the front-end to my database.. Sugar can use Oracle, MySQL (free) and Microsoft SQL-Server) on my office machine and each morning I take the latest sqldump from my server and re-generate the database on my Macintosh. Thus if my server takes a hit I can continue to work. True, I can still get out of sync, but I've only had one server hit in the past 4 years (for 10 minutes) so I'm not too worried. (I use Pair Networks (pair Networks - World Class Web Hosting) Great outfit to work with... the fix things in minutes, not hours... they are not cheap, but good service never is.)
When you decide on a software system you need to remember how important making backups are. My motto is "A backup an hour... in case things go sour."
Al
There are plenty of threads to read this battle with you Al. Quit being your annoying self. You going to the next miller parade?:bump: