[RESOLVED] ORDER BY Date/Time not working in access database 2007 in vb.net
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
Re: ORDER BY Date/Time not working in access database 2007 in vb.net
So I assume you mean that you switched the db format from .mdb to .accdb?
The version of access does not matter, the file format does but only as to what type of connection you need to open it.
What do you mean when you say it isn't working?
I see no reason to switch a working mdb to an accdb. newer versions of access can still talk to the older mdb format and older versions can talk to it as well. If you need more performance and/or space than you can get with a mdb file then you best bet is to move to SQL Server and forget Access altogether.
Re: ORDER BY Date/Time not working in access database 2007 in vb.net
Quote:
Originally Posted by
DataMiser
So I assume you mean that you switched the db format from .mdb to .accdb?
The version of access does not matter, the file format does but only as to what type of connection you need to open it.
What do you mean when you say it isn't working?
I see no reason to switch a working mdb to an accdb. newer versions of access can still talk to the older mdb format and older versions can talk to it as well. If you need more performance and/or space than you can get with a mdb file then you best bet is to move to SQL Server and forget Access altogether.
Thanks for your time
Greatly appreciated