M
mouse-klick.de
Hi,
i'd like to export an query with several queries nested in with Access 2007.
The DB is in Access 2003 mdb format.
With Access 2003 everything works fine.
In Access 2007 an export of the query to excel 2003-Format file fails with
the question after an parameter. The parameter name is a cut off of an field
name.
If i go one step further and try to export one of the nested queries the
same problem occurs and another parameter is asked for with a cuted off field
name, for example the parameter ' tablename.numbe' is asked for.
Thanks for your help.
Andreas Henke
mouse-klick.de
Hint: Does the Jetengine optimize the queries in Acc 2k7 in an other way as
Acc2k3? The single queries do work. The querie which i want to export only
fails during the export not in the normal viewing mode.
i'd like to export an query with several queries nested in with Access 2007.
The DB is in Access 2003 mdb format.
With Access 2003 everything works fine.
In Access 2007 an export of the query to excel 2003-Format file fails with
the question after an parameter. The parameter name is a cut off of an field
name.
If i go one step further and try to export one of the nested queries the
same problem occurs and another parameter is asked for with a cuted off field
name, for example the parameter ' tablename.numbe' is asked for.
Thanks for your help.
Andreas Henke
mouse-klick.de
Hint: Does the Jetengine optimize the queries in Acc 2k7 in an other way as
Acc2k3? The single queries do work. The querie which i want to export only
fails during the export not in the normal viewing mode.