About to upgrade to Office XP/ASP questions

[test guy]

I've got several small-time websites that use ASP to pull data from an
Access97 DB. Its worked fine thus far, but my server admin wants to upgrade
to Office XP. The last time we did this with Access 2000 it screwed up my
sites because the ASP wasn't able to retrieve data or make connections to
the DB appropriately (and I never could find out why!). I'm concerned this
could happen again with Office XP, and was wondering if anyone else could
offer any words of warning? Thanks!

 

[Glen SIdelnikov]

1. The request of your Admin to upgrade to Office XP has nothing to do with
ASP code you are running on the IIS (I guess?).
2. Even if your Admin upgrades to Office XP - it does not eliminate your
license on Access 97 and two (or even three) offices can run on the same
client computer.
3. FInally, if the request of your Admin is to convert to Access 2002
(Office XP); then you have to:
- Convert BackEnd database to Access 2002 from Access 97
- Check the links on your Web site. If they are done correctly, - you would
have to change the ODBS DNS on the IIS computer (probably that's why it
didn't work last time?).

 

[Adrian Leontovich]

You're right Glen.. we didn't change the DNS last time.. why the need to
change? Is there something specific that I'd have to select while changing
the ODBS DNS?

 

[Glen SIdelnikov]

1. MDW location
2. If you have two versions of Access installed, you should have two MS
Access ODBC drivers in your set (97 and 2002)


And again, since I do not know the real installation details, - I am
guessing