entering SQL into Access 2000 
Finally remembered how to submit a SQL line to an Access database. I knew it was possible just couldn’t remember how to do it.
- In the Database window, click Queries under Objects, and then click New on the Database window toolbar.
- In the New Query dialog box, click Design View, and then click OK.
- Without adding tables or queries, click Close in the Show Table dialog box.
- In the View menu (at the top) click on SQL View.
- Type in (or copy and paste) your SQL.
- Click the red exclamation point or go to the Query menu and click Run.
Do that as many times as you need to and skip all the M$ stuff tha gets in the way.