Hi there I'm having a problem trying to get the last record from my database.. I'm doing this:
Dim strSQL As String = "SELECT * FROM tblDatabaseRecords ORDER BY ID DESC LIMIT 1"
Dim myDataAdapter As New OleDbDataAdapter(strSQL, myConnection)
Form1.DataGridView1.DataSource = myDataTable
but it's saying "Syntax error in ORDER BY clause." Is there something wrong I am doing? Or can I get the last record of my database by another way?
Thanks in advance