Microsoft Jet database engine cannot find the input table or query

babyjek

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.)

msquared

Quote:

Originally Posted by babyjek

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?

Microsoft Jet database engine cannot find the input table or query

re: Microsoft Jet database engine cannot find the input table or query

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about