ms query error 3078 cannot find input table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lechu.555@gmail.com - 23 Oct 2006 20:25 GMT

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

Reply to this Message

Jerry Whittle - 23 Oct 2006 22:14 GMT

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

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi there,
>
[quoted text clipped - 12 lines]
>
> Jaume

Reply to this Message

lechu.555@gmail.com - 23 Oct 2006 22:31 GMT

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]"
[quoted text clipped - 18 lines]
> >
> > Jaume

Reply to this Message