By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

Conversion from Access 97 to Access 2000 (or XP)

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.