MS access 2007 query with param

See more:

C#

MS-Access

Microsoft

Hi

I am trying to selct some rows using this code.
When i use

cmd.CommandType = CommandType.TableDirect ;

error coming is too few parameters. and when i use

cmd.CommandType = CommandType.StoredProcedure ;

error is

Unspecified error
Invalid operation

I am using VS 2010 and ms office 2007 on windows
7 platform.

try
            {
                OleDbCommand cmd = new OleDbCommand("byjobtitle", cnn);
                cmd.CommandType = CommandType.TableDirect ;
                OleDbParameter prm = new OleDbParameter("@jobtitle", OleDbType.VarChar, 20);
                prm.Direction = ParameterDirection.Input;
                prm.Value = "Owner";
                cmd.Parameters.Add(prm);
                DataSet ds = new DataSet();
                OleDbDataAdapter da = new OleDbDataAdapter();
                da.SelectCommand = cmd;
                da.Fill(ds);
                return ds.Tables[0];
            }
            catch (Exception ex)
            { return null; }
            finally { cnn.Close(); }

I have done this before on using VS 2008 ans XP i didnt get any suxh errors. wasted my one day already. Please help.