Convert an Access2002 database to Access2007

[Steve]

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!

[Ed Robichaud]

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" <Em***@Invalid.comwrote in message
news:13*************@corp.supernews.com...

>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!

[Tony Toews [MVP]]

"Ed Robichaud" <ed*********@wdn.comwrote:

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

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/