Conversion from Access 97 to Access 2000 (or XP)

[Ken Abbott]

I'm having difficulty converting form 97 to 2000. Tables take forever
to open in design mode (queries, too). I have heard that if I build
form scratch instead of convert that the problem goes away. Anybody
figure this one out?

[Fletcher Arnold]

"Ken Abbott" <ab*****@post.harvard.edu> wrote in message
news:ad**************************@posting.google.c om...

I'm having difficulty converting form 97 to 2000. Tables take forever
to open in design mode (queries, too). I have heard that if I build
form scratch instead of convert that the problem goes away. Anybody
figure this one out?

If the tables are linked tables, try deleting them from the front end and
re-attaching them. I have found this to help where simply refreshing the
backend location caused the tables to open slowly.

In the backend (real) tables, make sure you turn off SubDatasheetName from
the design view.

Also when going from 97 to 2000, there may be confusion / conflict with
object libraries (DAO / ADO). Do make sure your database can compile
without errors - if the code is uncompiled this will adversly affect speed.
HTH

Fletcher

[John]

ab*****@post.harvard.edu (Ken Abbott) wrote in message news:<ad**************************@posting.google. com>...

I'm having difficulty converting form 97 to 2000. Tables take forever
to open in design mode (queries, too). I have heard that if I build
form scratch instead of convert that the problem goes away. Anybody
figure this one out?

You should be able to open it in 2000 and XP with no problem after it
converts. No doubt you will have to make some minor changes to some
reports and code. If you want send a zipped copy (97 version) to me,
so I can convert it up and see whats happening.

John
jr******@ureach.com