Re: Thinking of upgrading runtime from Access 97, but which version to get?
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Tue, 8 May 2007 14:47:39 -0500
ARC wrote:
Hello All,
I have a major application for quoting and invoicing that is written
in Access 97 (both front and back ends). I have a user base of over
300 customers, and currently I don't require that they have Access
97, as I use the access 97 runtime scripts from Sagekey software. The
main problems I've seen with Access 97 are the built in e-mail
support for sending reports. Unless a user uses the MS Outlook
2000/XP method, they have to go with either an .RTF (which doesn't
include graphics), or a Snapshot (which they don't like to do).
After catching up with some of the posts here, it sounds like the
.RTF issue still exists in Access 2003. This is ok, as long as 2003
will finally support the use of Outlook Express, using your own
defined attachments, and not requiring a full copy of Outlook 2000/XP
or later, for attachments. I guess I really have 3 options:
1) Stick with Access 97, and buy the updated Access 97 runtime
scripts from Sagekey that now supports Windows Vista installs. Buy an
e-mail add-in program that supports build in e-mails, .pdf
attachments, etc.
2) Buy Office Developer 2003 (not sure thist can still be purchased
anywhere), and new Access 2003 runtime scripts.
3) Buy the latest Office Developer 2007.
I do believe the e-mail handling, with lack of attachments such as
.pdf or .xls, in the default ms mapi functions, is the big drawback
of access 97. The positives of staying with 97 would be the reduced
size of the download, and possibly faster running speed of 97 (as
Microsoft software evolves, it generally requires faster hardware,
etc.)
I'm sure I'm missing many key features that have been added to the
2003 and 2007 versions of office, but it's really hard to find a link
comparing the feature sets of all versions of office. Can anyone
offer suggestions?
Many, many thanks!
There might be many reasons to upgrade (as well as some not to), but the
Email issues you describe have not changed much at all and will be no better
unless you go all the way to Access 2007.
There is a download you can add to Office 2007 that is supposed to provide
native PDF creation. I don't have any first hand knowledge of how that
works particularly as it pertains to generating them as Email attachments
though.
You can use ANY messaging library that can be automated from VBA code.
Unfortunately that rules out Outlook Express as it never has supported that
well (if at all). The problems with Outlook Express have always been an
issue with Outlook Express itself, not the version of Access you are using.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- Follow-Ups:
- Re: Thinking of upgrading runtime from Access 97, but which version to get?
- From: JustListenen
- Re: Thinking of upgrading runtime from Access 97, but which version to get?
- References:
- Prev by Date: Re: 2473 The expression On Menu you entered as the event property setting...
- Next by Date: Re: How do I dynamically create make-table queries
- Previous by thread: Thinking of upgrading runtime from Access 97, but which version to get?
- Next by thread: Re: Thinking of upgrading runtime from Access 97, but which version to get?
- Index(es):
Relevant Pages
|
