Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access 97 on Win XP: What are the risks?

Posted on 2004-04-20
6
Medium Priority
?
665 Views
Last Modified: 2008-03-06
Hi,

I have MS Access 97 running on my XP machine.  It seems working fine beside Access 97 lacks some great features that Access XP has.  Are there any risks of keeping Access 97 on an XP machine and why is it better to upgrade it to Access XP?

Thanks,
Tam
0
Comment
Question by:babytam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 10868795
Hello babytam,

The only reason to upgrade (voluntarily) is if you want the features that are available in the later version.
There is definitely NO benefit if all you want to do is go on running your existing application.

There are one or two useful programming features in XP but I wouldn't describe it as full of great new things.

Most developers want to be using the latest version at all times, just cos it exists.  This includes me.

Most corporate end-users don't have a choice about which version they use.

Pete
0
 
LVL 1

Author Comment

by:babytam
ID: 10869050
What about compatibility and stability?  Would the database be more stable over time if it upgraded to the latest version?

Tam
0
 
LVL 77

Accepted Solution

by:
peter57r earned 120 total points
ID: 10869181
Access97 was/is the most stable version of Access ever.

If you want to upgrade,then in my view, the only sensible upgrade today is to Office 2003.  
Online Help went downhill dramatically after A97 but in A2003 it's got a lot better again.
It will run your current database OK provided you aren't using third-party controls or the like. (But every upgrade should be tested first).

But you need reasonably up-to-date hardware and Win2000Sp3 or winXP to run it.  It's slower than A97 (but you expected that didn't you!)

Pete


0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 36

Expert Comment

by:SidFishes
ID: 10869432
"Online Help went downhill dramatically after A97"....that's a bit of an understatement...i'd say online help is virtually unusable in A2000...keyword searches in Access code help turn up Excel answers...i hate it i hate it i hate it...(umm...ok...i feel better now)


Something to consider...

http://support.microsoft.com/default.aspx?scid=fh;en-us;lifeOffice
Office 97 – Assisted support options on Office 97 ended January 16, 2004. Office 97 downloads for security issues will continue to be obtainable through normal assisted support channels at no charge during this time. Self-help online support will be available for at least one year after assisted support has concluded. Mainstream hotfix support for Office 97 ended on August 31, 2001, and extended hotfix support ended on February 28, 2002.

Note that all assisted support for Outlook 97 ended on December 31, 2001. Outlook 97 was succeeded by Outlook 98, which was provided free-of-charge to Outlook 97 customers and is supported under the same guidelines as Excel 97, Access 97, Word 97, and PowerPoint 97.
0
 
LVL 1

Author Comment

by:babytam
ID: 10869799
I'm thinking of migrating the data into a SQL Server and have Access as a Front-End.  Will Access 97 be compatible with SQL Server 2000 or later?

Tam
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 10869981
you can use dao to access server2k...but if you're going that route i'd suggest upgrading and taking full advantage of access adp's...

and as for the future server 2005 or whatever it will be...it wouldn't surprise me if A97 falls off the map...since support is already phased out...i can see ms leaving out backward compatibility to A97...

0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question