Converting from Access97 to Access 2003

[Richard Sherratt]

The system is an Access 97 front end to a SQL Server back end.
There's a whole heap of VBA code.
It has its own secure workgroup MDW.
It uses automation to open and modify Word, Excel, and Powerpoint
documents.
It uses automation to create Outlook mail items. e.g.

Set objNewMail = objOutlook.CreateItem(olMailItem)
With objNewMail ...

I haven't yet used Office 2003.

I've tried converting to Office 2000 and XP (the latest version I
have) and it seems to be OK.

Apart from the security hassle I've seen mentioned in here, are there
any general problem areas I should look out for?
--
Regards.
Richard.

[Tony Toews]

Richard Sherratt <ri**************@NOTHINGHEREbrunsley.com.au> wrote:

Apart from the security hassle I've seen mentioned in here, are there
any general problem areas I should look out for?

I'd consider using Late Bind just in general cases so as to drastically reduce any
problems with different versions of Word, Excel, PPT and Outlook. But I'm not sure
I'd put it in place right now either. Make sure the app is running smoothly first
and then put one of these in place a day or something like that.

For more information including additional text and some detailed links see the "Late
Binding in Microsoft Access" page at http://www.granite.ab.ca/access/latebinding.htm

There are some minor problems I've encountered at Access 2.0 and Access 97 to Access
2000/2002 conversion issues/problems/bugs
http://www.granite.ab.ca/access/conversionproblems.htm

I'd suggest giving a copy of the new FE to a few power users to use for a few weeks
to locate any problems. A lot easier than rolling out a new version and having a
bunch of problems all coming your way at once. And all which need fixing ASAP.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Richard Sherratt]

On Tue, 24 Feb 2004 01:54:49 GMT, Tony Toews <tt****@telusplanet.net>
wrote:

<snip>

Tony

Thanks, Tony. Fingers crossed :-)
--
Regards.
Richard.