ORDER CLAUSE IN QUERY

See more:

C#

Dear all,
I am doing a Windows Form where I had to auto generate a Job code which is unique.
This I had done by selecting the last row added from the database and incrementing jobpk(auto generating primary key) with one and concatenating with a string code.

I had code as below, but the query returns an exception at

dAdapter.Fill(ds, "tbljobrdataview");

Syntax error in ORDER BY clause.

My code is:

public void newjobecodenoget(){
           OleDbConnection oleDbConnection1 = new System.Data.OleDb.OleDbConnection(connString);
           oleDbConnection1.Open();


           String query = "Select jobpk from jobcodemastertable ORDER BY jobpk DESC LIMIT 1";
           OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString);


           DataSet ds = new DataSet();

           dAdapter.Fill(ds, "tbljobrdataview");
           Int32  S = int.Parse(ds.Tables[0].Rows[0][0].ToString());
           S++;
            MessageBox.Show("" +S);
            String jobcodeno = "NFT" + S.ToString();
            txtjobcode.Text = jobcodeno.ToString();

       }

I call this function at constructor and I am using Access database.
jobpk is primary key in long integer format.

Can anyone help to sort out my mistake?

I have tried using quotes('') to jobpk in query but same result