By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,847 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,847 IT Pros & Developers. It's quick & easy.

Microsoft Jet database engine cannot find the input table or query

P: 1
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
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.