Access 2002 Sample Database Wizards

[Guest]

In Office 2002, there are only ten sample database wizards. In Office 97,
there were over twenty. These wizards allowed the user to specify what
fields were to be included in the database. Is there a way to convert the
Office 97 wizards for use in Office 2002?

I know Microsoft has posted under their "Templates" actual final designed
databases that replace what these wizards built, but you now have to accept
what fields they provided. For example, the old "Music Collection" wizard
allowed optional fields for "Purchase Date, Price, etc." but the Template
version does not provide these.

I find the sample database wizards more useful than the template databases
now provided.

Is there a way to use the old Office 97 Wizards?

 

[Albert D. Kallal]

Is there a way to use the old Office 97 Wizards?

Hum, I don't see why you can't create the database on the old system..and
then move it to the machine with a2002.

a2002 should convert that database to a2002 format without troubles...

 

[Brendan Reynolds]

You can't convert the wizards, but you can, as Albert suggests, convert
databases created using the 97 wizards. There is one issue to watch for. The
97 databases will contain a line of code that calls a function in
'wzmain80.mda'. In later versions of Access, the name of this MDA has
changed to 'acwzmain.mda'. Make that change, and the database should be OK
in 2000, 2002, or 2003.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.