running access 97 on windows XP

[JulieD]

are there any known problems with this?

cheers
JulieD

 

[John Vinson]

are there any known problems with this?

cheers
JulieD

It's been working just fine for me for the past year or so.

 

[JulieD]

Hi John

thanks for the quick response - the full story is that i'm developing an
access database which exports data and they wanted it in access 97 exporting
to excel 97 and now one of the principles has commented:

"I am replying early as there are concerns about the use of Access 97 and
Excel 97. Our host agency is moving from Access 2000 to XP. I cannot
confirm, at this time, if the Department can supply Access 97 and Excel 97
and whether they will support the software. I am told that these older
packages are not fully compatible with XP and some conflicts occur with
printing reports and exporting text forms."

have you heard about these report printing / exporting problems?

Cheers
Julie

 

[Ed Warren]

I have run into the following problem with Win 2000 and WinXp using
Access97. The link below is to the White Paper discussing it. (Need to
register the DA0 for Access 97).

I have also had problems with the Switchboard if I build in Access
2000/xp/2003 and then convert to Access97.

Cheers,

Ed Warren

http://support.microsoft.com/default.aspx?scid=kb;en-us;303829

ACC97: Error Message: "Compile Error: Function or Interface Marked as
Restricted, or the Function Uses an Automation Type Not Supported in Visual
Basic"

This article was previously published under Q303829

 

[John Vinson]

Hi John

thanks for the quick response - the full story is that i'm developing an
access database which exports data and they wanted it in access 97 exporting
to excel 97 and now one of the principles has commented:

"I am replying early as there are concerns about the use of Access 97 and
Excel 97. Our host agency is moving from Access 2000 to XP. I cannot
confirm, at this time, if the Department can supply Access 97 and Excel 97
and whether they will support the software. I am told that these older
packages are not fully compatible with XP and some conflicts occur with
printing reports and exporting text forms."

That's a VERY DIFFERENT QUESTION! Your original question was about the
WindowsXP operating system; this is about compatibility between Access
(Office) 97 and Office XP programs. Microsoft makes it confusing! "XP"
applies to the operating system and to application software, but it's
almost completely independent.

Access97 works fine (with a few quirks, note elsethread) under the
WindowsXP operating system.

However, Access97 cannot read, update, or interact with AccessXP
databases (although AccessXP can use Access97 databases). You can
create a database in AccessXP and save it in Access97 format for use
with an existing installation of Access97, although of course new
features that did not exist in 97 will not be converted.

 

[kevinrea]

that i have heard of ..
been using it quite a while.. works nice.

 

[JulieD]

thanks all for your replies

i'm writing the DB in 97 and have decided to give the end users the choice
of
1) installing and running access 97 along side whatever other versions they
have
2) converting the front end to whatever version of access they want to use
hopefully i won't run into any problems with these options.

Regards
julieD