ms query error 3078 cannot find input table

[lechu.555]

Hi there,

I am trying to retrieve to Excel a query from Access; that query got a
date field I am capping with a criteria like this
<=DMax("Week","Tbl_Data) because I need only records up to the latest
date from that table. In Access all works well.

When in Excel and trying to retrieve the Access Query with MS Query, it
gives me the 3078 error that Ms Access database jet engine... cannot
find input table or query 'xyz'

How can I sort that out?

Thanks in advance

Jaume

 

[Guest]

Maybe a type but "Tbl_Data doesn't have closing double quotes. Also "Week"
should have brackets around it like: "[Week]"

 

[lechu.555]

thanks Jerry; if I use [Week] the query understands it as a parameter
input. You are right, I made a typo in the mail, but not in the query.

Through further research I learned that the problem is (I tested it) is
that the my query derives from a link table to another access dB.

Any help extremelly appreciated.

Jaume

Maybe a type but "Tbl_Data doesn't have closing double quotes. Also "Week"
should have brackets around it like: "[Week]"
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hi there,

I am trying to retrieve to Excel a query from Access; that query got a
date field I am capping with a criteria like this
<=DMax("Week","Tbl_Data) because I need only records up to the latest
date from that table. In Access all works well.

When in Excel and trying to retrieve the Access Query with MS Query, it
gives me the 3078 error that Ms Access database jet engine... cannot
find input table or query 'xyz'

How can I sort that out?

Thanks in advance

Jaume