Access 97 to Access XP Conversion Issues

[Jovi Tsui]

Hi Jay,

I am new to the newsgroup. Regarding Access 97 to Access
XP conversion issues, i have two questions below.

1. When I run Access 97 program in WinXP platform (client
side), I failed to upload data from SQL 7.0 (server side)
to Access 97 databases. I just wonder whether there has
any ODBC driver requirement for Access 97 running in WinXP
platform to transmit data from SQL Server 7.0 to Access
97. Please advice.
2. For conversion from Access 97 to AccessXP, is there any
automatic toolkits?? How large is the difference between
Access 97 and AccessXP in terms of syntax, objects and
etc?? If i am going to do conversion, what procedures
should i follow?? Please advice.

Much appreciated for your help in advance !! ^o^

Best Regards,
Jovi

-----Original Message-----
I have converted an application developed in Access 97 to

a Access Xp Version. Now, in itâ?Ts native Access 97
format, the application runs fine and fast. However, once
converted to Access Xp, it runs slower than a snail. I
have compiled and saved all the modules in the Access 97
database prior to the conversion. Everything compiled
Okay, no errors what so ever!

Later I used the method suggested in the knowledge

article: 286341, which speaks of creating an empty Xp
database container, then, importing the needed components
(queries, forms, report, macros, modules) into it. Still
it runs slow!