472,145 Members | 1,528 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Microsoft Jet database engine cannot find the input table or query

SELECT ProjectID, ProjectName, ProjectDescription, SequenceNumber, LastUpdateDate
FROM Project
WHERE ProjectID = @ProjectID;

(The Microsoft Jet database engine cannot find the input table or query 'Project'.
Make sure it exists and that its name is spelled correctly.)
Sep 19 '07 #1
1 8229
MMcCarthy
14,534 Expert Mod 8TB
SELECT ProjectID, ProjectName, ProjectDescription, SequenceNumber, LastUpdateDate
FROM Project
WHERE ProjectID = @ProjectID;

(The Microsoft Jet database engine cannot find the input table or query 'Project'.
Make sure it exists and that its name is spelled correctly.)
OK the obvious questions.

Have you got a table named Project? Check the spelling including capital letters etc.
Is it a local table in your Access database or is it linked?
Sep 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by josh.kuo | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.