Incorrect syntax near keyword “ORDER"

[k9drh]

I’m lost I hope someone can point me in the right direction.
I created a access database using 2003 years ago and have upgraded to 2007.
The actual database standalone works great. The first form I call on opening the database is a switchboard which was created using database tool switchboard manager.


Now comes the problem, I am upsizing this database to SQL Server Express 2008 R2 (Client/Server).
The database completes and the report shows no problem.
When you double click the database to open it I get the following error message:
“Incorrect syntax near keyword “ORDER””
Hence the problem I don’t know where to look to correct this. Looks to be in the MS code and not something I created in VBA.
every time you click form "Switchboard"
Any suggestions would be appreciated.

[SoftwareMatters]

Have you checked the recordset behind the form (if there is one)?

Do you get a debug option?
If so have you tried stepping through?
If not try putting a break point on the OnOpen even of the main switchboard and see what happens when you try to open it.