I have been asked to convert an Access2002 database to Access2007. The
database is used to manage a medium sized company. The company contact said
that the existing database was put on a new computer with Access2007
installed and parts of the database did not work. There are about 75 tables,
40 queries, 90 forms and 35 reports. My initial planned strategy is to keep
a list at my right hand of all the queries then open each form one by one.
For each form I would test and fix if necessary any combobox and any listbox
and check off the query if the row source is a query. I would then go to the
form's code window and test and fix if necessary each code procedure. After
going through the forms, I plan to similarly go through each report. If
there are any remaining unchecked queries, I will determine if/where they
are used and delete or test and fix if necessary. There are no standard
modules.

I would like comments on this planned strategy and any suggestions.

Thanks!

On Sun, 2 Mar 2008 19:38:38 -0500, "Steve" <Email (AT) Invalid (DOT) com> wrote:

You have a decent plan, but it starts at stage 2 rather than stage 1.
In the first stage you would find out what the requirements are. You
can't assume the requirements have been implemented correctly and have
not changed over time.

I would not be overly concerned about a few unused queries.

-Tom.

Thanks for responding, Tom!

<..... the requirements have been implemented correctly .....>

The CEO developed the database so that is a given <g>



"Tom van Stiphout" <no.spam.tom7744 (AT) cox (DOT) net> wrote

Normally, I'd check for any missing references (VBA-tools-references), but
it's odd that a database of this size has no modules.

The only 2007 conversion problems that I've noted in my 2000-2003 programs,
is that many of the continuous forms that have a filter-by-multi combobox
strategy, needed to have their recordsource declared on opening to work
properly.

-Ed



"Steve" <Email (AT) Invalid (DOT) com> wrote

"Ed Robichaud" <edrobichaud (AT) wdn (DOT) com> wrote:

See previous comment about CEO developing the system. <chuckle>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/