Named a table “order” in Microsoft Office Access database and the webapp now can't see the table (even after renaming it)

I am creating a web application in Dreamweaver using ASP VBScript. The web application is a store and I have to implement a database into it (which I did). I created a table in my database called order and for some reason I couldn't dynamically enter the data from a record set that I wanted to. I searched on Google and came across someone saying that order is a reserved word and that I should name my table something else. I did so (several times, several names, and even new tables with the same fields, thinking I could use this table, no joy.) But ever since, whenever I try to create a new recordset I am only picking up the old table (the one named order, the other two table are working fine).  I couldn't see the new renamed table fields when creating a recordset no matter how much I refreshed the database window.  I am able to access the database that I want to use when I double click the database through Local view or Remote View (I can't find the old DB anywhere). The problems arise when I want to use the data from the order recordset (since this is the recordset it is forcing me to use even though I can't). I am getting this error when I press on the + button of the recordset that is related to the order table > [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. So when I go and change this code to the name of an existing table in my DB (which is now orders) I then get this error > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Office Access database engine cannot find the input table or query 'Orders'. Make sure it exists and that its name is spelled correctly' . Here's the DB:  Here's the code where the problem is: I can't create a brand new DB and start over because I need my lectures login credentials as it is on the college's server and it's a bit too late to do that now, sadly.