Book a Demo

Author Topic: Failing to generate document using access 2007  (Read 5398 times)

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Failing to generate document using access 2007
« on: May 12, 2009, 09:36:44 pm »
Whent rying to generate reposrts (even basic report)  I get error: "Datatype mismatch in criteria exception", then it fails to generate.
7.1 is the same.
Comunicated to Sparx.
Recursion definition:
If you don’t understand the definition read "Recursion definition".

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Failing to generate document using access 2007
« Reply #1 on: May 12, 2009, 09:53:10 pm »
Hi Martin,

What do you mean by "using" Access 2007?

David
No, you can't have it!

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: Failing to generate document using access 2007
« Reply #2 on: May 12, 2009, 10:00:28 pm »
Connected to Access2007 instead of EAP or DB.
Recursion definition:
If you don’t understand the definition read "Recursion definition".

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Failing to generate document using access 2007
« Reply #3 on: May 13, 2009, 09:01:42 am »
I don't actually know if you can. AFAIK EA does not support the new format, and perhaps not even the new (2007) engine against the old format.
No, you can't have it!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Failing to generate document using access 2007
« Reply #4 on: May 13, 2009, 10:22:16 am »
I've used Access 2007 to generate Access reports against both EAP files and server databases using linked tables.

I think I had the datatype mismatch early on.  Do you know which columns are causing it?

Are you connecting to an EAP or server DB?

HTH,
Paolo
« Last Edit: May 13, 2009, 10:24:33 am by PaoloFCantoni »
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: Failing to generate document using access 2007
« Reply #5 on: May 15, 2009, 02:39:02 am »
I connect to it through ODBC (as to DB) this capability is available in EA since 7.1.
Recursion definition:
If you don’t understand the definition read "Recursion definition".

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: Failing to generate document using access 2007
« Reply #6 on: May 17, 2009, 03:09:32 pm »
Quote
Thanks for the report.

This issue has been logged with ID 09052635.

We hope to have in resolved for the next release.
Recursion definition:
If you don’t understand the definition read "Recursion definition".