Access 2002 conversion back to Access 1997 error

[Maurice]

Folks

once again I look forward to your invaluable assistance.

When converting an Access 2002 mdb back to Access 1997 using the Access 2002
inbuilt tools I receive the following error message "Some errors happened
during the conversion. No converted database was generated". This message is
not of great assistance to me in sorting out the error!!

I have not been able to find any helpful support on where to start looking
to resolve whatever it is that is causing the error.Can anybody point me to
where to start?

TIA
Maurice
email: mauricel at ihug dot com dot au

[Allen Browne]

Re: Access 2002 conversion back to Access 1997 error

1. Turn the off Name AutoCorrect boxes under Tools | Options | General. For
more information on these problems, see:

http://allenbrowne.com/bug-03.html

2. Compact the database (Tools | Database Utilities | Compact) to get rid of
any temp objects.

3. Open a code window, and choose References from the Tools menu. Deselect
any references you do not need. For conversion to A97 it would be helpful to
have only the Access, VBA, and (if needed) DAO libraries. After delelecting
the others, make sure your code compiles (Compile on Debug menu).

Try the conversion again. If it still fails, try creating a new (blank)
A2002 database, turn off Name AutoCorrect, remove spurious references, and
import everything from your problem database: File | Get External | Import.
Then try the conversion from this newly recreated database back to A97.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Maurice" <maurice@nospam .com> wrote in message
news:c1219r$6t4 $1@lust.ihug.co .nz...[color=blue]
>
> once again I look forward to your invaluable assistance.
>
> When converting an Access 2002 mdb back to Access 1997 using the Access[/color]
2002[color=blue]
> inbuilt tools I receive the following error message "Some errors happened
> during the conversion. No converted database was generated". This message[/color]
is[color=blue]
> not of great assistance to me in sorting out the error!!
>
> I have not been able to find any helpful support on where to start looking
> to resolve whatever it is that is causing the error.Can anybody point me[/color]
to[color=blue]
> where to start?
>
> TIA
> Maurice
> email: mauricel at ihug dot com dot au[/color]

[Maurice]

Re: Access 2002 conversion back to Access 1997 error

Allen

Thanks for the advice. Alternative 1 failed, so have created a new database
and imported from the "current". Conversion succeeded. Will email new 1997
version to my remote user to see if this version can be opened. Won't know
until after the current weekend. Will let you know the result.

TIA
Maurice
"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
news:40348eaf$0 $22519$5a62ac22 @freenews.iinet .net.au...[color=blue]
> 1. Turn the off Name AutoCorrect boxes under Tools | Options | General.[/color]
For[color=blue]
> more information on these problems, see:
> http://allenbrowne.com/bug-03.html
>
> 2. Compact the database (Tools | Database Utilities | Compact) to get rid[/color]
of[color=blue]
> any temp objects.
>
> 3. Open a code window, and choose References from the Tools menu. Deselect
> any references you do not need. For conversion to A97 it would be helpful[/color]
to[color=blue]
> have only the Access, VBA, and (if needed) DAO libraries. After[/color]
delelecting[color=blue]
> the others, make sure your code compiles (Compile on Debug menu).
>
> Try the conversion again. If it still fails, try creating a new (blank)
> A2002 database, turn off Name AutoCorrect, remove spurious references, and
> import everything from your problem database: File | Get External |[/color]
Import.[color=blue]
> Then try the conversion from this newly recreated database back to A97.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Maurice" <maurice@nospam .com> wrote in message
> news:c1219r$6t4 $1@lust.ihug.co .nz...[color=green]
> >
> > once again I look forward to your invaluable assistance.
> >
> > When converting an Access 2002 mdb back to Access 1997 using the Access[/color]
> 2002[color=green]
> > inbuilt tools I receive the following error message "Some errors[/color][/color]
happened[color=blue][color=green]
> > during the conversion. No converted database was generated". This[/color][/color]
message[color=blue]
> is[color=green]
> > not of great assistance to me in sorting out the error!!
> >
> > I have not been able to find any helpful support on where to start[/color][/color]
looking[color=blue][color=green]
> > to resolve whatever it is that is causing the error.Can anybody point me[/color]
> to[color=green]
> > where to start?
> >
> > TIA
> > Maurice
> > email: mauricel at ihug dot com dot au[/color]
>
>[/color]