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]

Re: Convert an Access2002 database to Access2007

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@Invalid. comwrote in message
news:13smi4fe89 e5h6e@corp.supe rnews.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]]

Re: Convert an Access2002 database to Access2007

"Ed Robichaud" <edrobichaud@wd n.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/