Hello there

Am developing a project and is near completion. I was using Access database 2002-2003 format but decided to change to Access database 2007 thinking Access 2003 may be old and Access 2007 may have more storage size.
Now my problem is ORDER BY seem not to work in Access 2007 which wasn't the case in Access 2003
Queries like this


Code:
"SELECT bsStudID,bsSurname,bsOthername,bsGender,bsClass,bsAmtDue,bsAmtPaid,bsDatePaid,bsReceiptNo,bsCashier FROM BookSalesHistory ORDER BY bsDatePaid ASC,bsStudID ASC "

"SELECT rStudID,rSurname,rOthername,rDOB,rGender,rClass,rStudType FROM SchRegister ORDER BY rGender DESC,rSurname ASC "
they were working perfectly before i switched to Access 207 but isn't working again.
1.Is there anything that am missing
2.Is it even a good idea that for switch from Access 2003 to 2007?

thanks