By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Converting from Access97 to Access 2003

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

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

<snip>
Tony


Thanks, Tony. Fingers crossed :-)
--
Regards.
Richard.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.