When i try to query MsysObjects table following error is caught(try-catch).
Database error: Too few parameters.Expected 2.
These are the two lines used to run the SQL query in vc++.
// Build the SQL statement
SqlString = "SELECT Name FROM MSysObjects where type = 1 AND (Left([Name],4) <> \"Msys\") AND (Left([Name],1) <> \"~\")";
// Execute the query
I think you will have more chance of gettign an answer if you post the question in the C / .NET threads rather than the Access thread, you could also try to see the examples in the help system. The error message tells you that the line that is failing is supplying too few parameters.
deos the intellisense give any suggestions - i'd guess you are possibly using the wrong recordset type, or wrong sequence of parameters for what you want to achieve